:::: MENU ::::

List the database fixed roles with permissions

  • Jun 26 / 2012
  • 0
dbDigger

List the database fixed roles with permissions

While working with permissions, DBAs have to consult and make use of fixed database roles. To get a list of DB roles along with their permissions here is a couple of system stored procedures.

  • sp_helpdbfixedrole (Displays list of the fixed roles)
  • sp_dbfixedrolepermission (Displays the permissions for each fixed role)

These may be used for broad level information. BOL or other sources may be consulted for details.

Consult us to explore the Databases. Contact us