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.