Post reply

General Script or Method to Query/Report Permissons for a SQL Server Instance

  • April 28, 2014 at 9:35 am

    #288267

    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.

  • April 28, 2014 at 9:55 am

    #1709219

    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!

  • April 28, 2014 at 12:10 pm

    #1709245

    Thanks a lot. I am going to check them out.

  • May 7, 2014 at 5:24 am

    #1711433

    This is very usefully for me 🙂

    ______________

    fast weight loss pills, how to lose weight, slimming pills,cha de bugre

    🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply