Anyone have a script that will script out all server/database-level permissions for a specific login, across ALL databases?

• doodlingdba

  Hall of Fame

  Points: 3164

  More actions

  May 2, 2018 at 4:31 am

  #344536

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738643

  More actions

  May 4, 2018 at 10:12 am

  #1989317

  You'll have to look through these: http://www.sqlservercentral.com/search/?q=user+login+permissions&t=s&sort=relevance

• Thom A

  SSC Guru

  Points: 99143

  More actions

  May 4, 2018 at 10:14 am

  #1989318

  This is actually a duplicate: https://www.sqlservercentral.com/Forums/1934592/Script-out-all-permissions-across-all-databases-for-a-specific-user

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk