Server Logins permission on each user db

• khushbu

  SSCarpal Tunnel

  Points: 4591

  More actions

  November 30, 2011 at 5:09 am

  #247714

  Hello,

  Would like to know if you have any handy script that pulls all the roles, permission access for each login on server/database.

  For eg. Login "prodsql" has public,exec_role on db1, db2

  I would need such details.

  I have some scripts but they pull data from each db. While i'm looking to pull data from master db, so that i can run them on say mirrored db etc

  Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 30, 2011 at 9:33 am

  #1414778

  Well, you can't get info about database roles and object permissions just from Master. That data is stored in each database.

  Have you checked the script section here at SSC? I'm pretty sure I've used one that does what you want, but I can't remember what it's called.

  Greg