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

General Script or Method to Query/Report Permissons for a SQL Server Instance Expand / Collapse
Author
Message
Posted Monday, April 28, 2014 9:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:03 PM
Points: 47, Visits: 146
Hello,

Is there a general SQL script or method for putting together a list of all users and permissions for a specific SQL Server instance? I am needing to put together a summary of all permissions on a specific SQL Server 2005 database.

Any suggestions are greatly appreciated.
Post #1565631
Posted Monday, April 28, 2014 9:55 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 12,905, Visits: 32,165
there are quite a few script contributions here on SSC; some are detailed, some script out as commands, some are more overview/report like, so it really depends on what you like.

take a look here, and see if you find one that you like:

http://www.sqlservercentral.com/search/?q=script+permissions&t=s&sort=relevance


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1565637
Posted Monday, April 28, 2014 12:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:03 PM
Points: 47, Visits: 146
Thanks a lot. I am going to check them out.
Post #1565671
Posted Wednesday, May 7, 2014 5:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 5:41 AM
Points: 2, Visits: 3
This is very usefully for me :)
______________
fast weight loss pills, how to lose weight, slimming pills,cha de bugre


:)
Post #1568389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse