Display Table Permisions by Role

• dmessmer

  SSC Veteran

  Points: 222

  More actions

  June 4, 2010 at 9:57 am

  #221862

  Hello,

  We are implementing a new piece of software and have been given a sample database with sample database roles that we are modifying to suit our specific needs. I am trying to find an efficient way to determine what permissions are granted on specific tables for a given role.

  Is there a stored procedure or a script available that will display table permissions granted for a specific role?

  Thanks.

  Dave

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  June 7, 2010 at 3:53 am

  #1176981

  I think that this can be a good starting point

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