Post reply

Scripting user login permissions

  • April 11, 2005 at 10:23 am

    #88678

    Hi everyone, I want to write a script that will get me the following info:

    1. User in a database.

    2. Users permissions in that database.

    3. Which roles the user belongs to.

    Which sys tables would I find this info at? Thanks in advance for your help.

  • April 11, 2005 at 11:15 am

    #551908

    I used to use a number of queries against the system tables to derive this information but I found a link on this site to a very nice tool which does all this for you.  Here is the link to the artical:

    http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp

  • April 11, 2005 at 2:43 pm

    #551961

    Wow, thank you for that tool! It turly is a great tool. Thanks a million.

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

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