Post reply

list all the user permissions

  • March 10, 2009 at 9:11 am

    #202134

    is there a way to list all the permissions for a specific user across multiple databases?

  • March 10, 2009 at 9:29 am

    #956890

    use the search in the upper right for "script user permissions"

    there are like ten different versions of scripts in the contributions section that does exactly this;

    this is the one i just played with:

    http://www.sqlservercentral.com/scripts/31776/[/url] and it seems to do a nice job

    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!

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

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