Single Query to find permissions

• curious_sqldba

  SSC-Dedicated

  Points: 36494

  More actions

  December 2, 2010 at 3:50 pm

  #229357

  I need one query to find out the following things about a given login:

  i) type of access to each db if any

  ii) type of access to individual objects

  iii) type of access at server level.

  basically i need to find what access does a login have on the server. Would like to go as granular as possible.

  Thanks

• curious_sqldba

  SSC-Dedicated

  Points: 36494

  More actions

  December 6, 2010 at 12:30 pm

  #1259179

  Any advice?

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  December 6, 2010 at 1:04 pm

  #1259196

  Please check if this helps

  http://consultingblogs.emc.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions--_2800_2_2900_.aspx

  http://www.builderau.com.au/program/sqlserver/soa/Reviewing-SQL-Server-Permissions/0,339028455,339293054,00.htm

  Thank You,

  Best Regards,

  SQLBuddy

• curious_sqldba

  SSC-Dedicated

  Points: 36494

  More actions

  December 6, 2010 at 3:59 pm

  #1259278

  thanks