T-Sql crear acceso solo lectura

use BBDD
go
create login ReadOnly with password='TuPasswd';
GO
create user ReadOnly for login ReadOnlyDPN;
GO
--Acceso ReadOnly
GRANT SELECT  TO ReadOnly WITH GRANT OPTION;
go