Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Today @ 4:26 PM
Points: 14,189, Visits: 37,089
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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