Post reply

Find the List of Users and the roles ,privilieges in SQL Server

  • November 4, 2009 at 3:42 pm

    #217142

    Hi, I have a requirement .I need to get the login details of all the users in sql server,their privileges,and their access to each database and tables .

    I could get the login information from the following query but not in detail

    SELECT * FROM master.sys.server_principals

    Appreciate your help.

    Demin

  • November 4, 2009 at 4:14 pm

    #1075084

    Check the scripts repository.

    SSC Security Scripts[/url]

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 4, 2009 at 5:55 pm

    #1075103

    Go to MSSQLTips.com and search for Michelle Gutzait work she has posted some sample code that will do all that you seem to want and then some more.

    Written By: Michelle Gutzait -- 8/18/2009

    MSSQLTips.com

    brought to you by Edgewood Solutions

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • November 5, 2009 at 5:26 am

    #1075264

    Thanks to both of you.

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

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