Add users with read permissions

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Rafeeque M.K. Ten Centuries Points: 1205 More actions · Answer 1

Ten Centuries

Points: 1205

May 6, 2005 at 1:53 am

try to write a script using sp_adduser sps

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 2

exec sp_msforeachdb "use ?;exec sp_adduser 'username', 'username';"

exec sp_msforeachdb "use ?;exec sp_addrolemember 'db_datareader', 'username';"

You could use a cursor to loop through the list of users that you want to add.