Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Reader Permission Expand / Collapse
Author
Message
Posted Monday, October 6, 2008 10:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 8, 2008 9:41 PM
Points: 29, Visits: 113
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.
Post #581508
Posted Tuesday, October 7, 2008 2:49 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:00 PM
Points: 4,064, Visits: 5,326
It would be easier to offer advice if you post what happened when you executed sp_addrolmember. I'm going to guess you got an message that said something like, "User 'Username' doesnot exist in this database". A login has to be granted access to a database before it can be a member of a fixed database role.

Greg
Post #582195
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse