Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 7,2000 » Security » db_datareader permission for a login
Add to briefcase

db_datareader permission for a login Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
jamessdba
Posted Monday, November 26, 2012 4:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:36 PM
Points: 72, Visits: 797
we have 15 Database in our server how can i give at a time db_datareader permission for all DB 's for One login

Post #1388519
John Mitchell-245523
Posted Monday, November 26, 2012 4:48 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:18 PM
Points: 4,434, Visits: 7,219
Something like this:

SELECT 'USE ' + name + ' EXEC sp_addrolemember ''db_datareader'', ''myusername'''
FROM master..sysdatabases

That will generate the SQL to add the user to the role in each database. This assumes that the login is mapped to the same user name in each database.

John
Post #1388530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.