Post reply

Script out all permissions across all databases for a specific user

  • May 3, 2018 at 3:04 am

    #328608

    Hi there 

    I have gathered a number of scripts over the years that give me partial info but what I would like is one script that tells me all permissions (server level permissions, server role membership, database level permissions, database role membership) for a specific login, across ALL databases?
    If anyone has anything like this that they'd like to share, i'd be very grateful!

    Thanks
    Doodles

  • May 3, 2018 at 2:45 pm

    #1989196

    doodlingdba - Thursday, May 3, 2018 3:04 AM

    Hi there 

    I have gathered a number of scripts over the years that give me partial info but what I would like is one script that tells me all permissions (server level permissions, server role membership, database level permissions, database role membership) for a specific login, across ALL databases?
    If anyone has anything like this that they'd like to share, i'd be very grateful!

    Thanks
    Doodles

    You can try this script:http://www.sqlservercentral.com/scripts/Permissions/64309/

    Alex S

  • May 4, 2018 at 4:11 am

    #1989239

    Thanks Alex, the script is awesome 🙂

    Cheers!

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

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