We have nearly more than 100 user DB's in a Server in 2005.
I wanted to give Datareader permission to all most of the DB's using Query.
We have nearly more than 40 logins in this server.
Plz tell me a procedure to give Data_reader permission.
I tried this , but not working
EXEC sp_addrolemember 'db_datareader', 'Username'
Please give me a solution for me to perform task easier.
Thanks for all those answering.