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

SQL Query to get all the databases and permissions on them for a login Expand / Collapse
Author
Message
Posted Tuesday, October 16, 2012 4:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 4:21 AM
Points: 2, Visits: 43
Hi,
I have situation where i need to prepare a report to find all the users and what access have they got to the databases in the server. So basically i need a login name and what are all the databases they can access to and what sort of permission they have on those databases. Can some one help me to get these information from system tables as i dont have much knowledge on them.

Regards,
Ram
Post #1373103
Posted Wednesday, October 17, 2012 6:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:35 PM
Points: 191, Visits: 898
See the following url for an Instance Security Audit script I wrote. Hope it helps.

http://www.sqlservercentral.com/Forums/Topic1251262-146-1.aspx?Update=1
Post #1373767
Posted Thursday, October 18, 2012 2:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 4:21 AM
Points: 2, Visits: 43
Thanks so much for your prompt response. l Really aprreciate it :)
Post #1374197
Posted Thursday, October 18, 2012 4:41 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 21, 2014 10:47 AM
Points: 258, Visits: 1,093
Wow! Awesome script. Thanks for sharing it.
Post #1374610
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse