List of database roles and permissons

• Julianne Yeaman

  Valued Member

  Points: 64

  More actions

  April 29, 2005 at 11:23 am

  #164414

  Newbie warning!!

  Is there an easy way to list the user roles and table permissons granted to those roles for a given database?

  TIA,

  Julianne

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  April 29, 2005 at 11:54 am

  #556052

  sp_helprole

  EXEC sp_helprotect NULL, 'YourDatabaseRole'