SQL Query to get all the databases and permissions on them for a login

• ramcp14

  Grasshopper

  Points: 22

  More actions

  October 16, 2012 at 4:06 am

  #265778

  Hi,

  I have situation where i need to prepare a report to find all the users and what access have they got to the databases in the server. So basically i need a login name and what are all the databases they can access to and what sort of permission they have on those databases. Can some one help me to get these information from system tables as i dont have much knowledge on them.

  Regards,

  Ram

• vikingDBA

  SSCertifiable

  Points: 5356

  More actions

  October 17, 2012 at 6:48 am

  #1549983

  See the following url for an Instance Security Audit script I wrote. Hope it helps.

  http://www.sqlservercentral.com/Forums/Topic1251262-146-1.aspx?Update=1

• ramcp14

  Grasshopper

  Points: 22

  More actions

  October 18, 2012 at 2:48 am

  #1550336

  Thanks so much for your prompt response. l Really aprreciate it 🙂

• Gail Wanabee

  SSCrazy Eights

  Points: 8471

  More actions

  October 18, 2012 at 4:41 pm

  #1550704

  Wow! Awesome script. Thanks for sharing it.