Returns a list of the fixed database roles.
Fixed database roles, as shown in the following table, are defined at the database level and have permissions to perform specific database-level administrative activities. Fixed database roles cannot be added or removed. The permissions granted to a fixed database role cannot be changed.
Fixed database role
Database access administrators
Database security administrators
Database DDL administrators
Database backup operators
Database data readers
Database data writers
Database deny data readers
Database deny data writers
The following table shows stored procedures that are used for modifying database roles.
Adds a database user to a fixed database role.
Displays a list of the members of a fixed database role.
Removes a member from a fixed database role.
Requires membership in the public role.
Information returned is subject to restrictions on access to metadata. Entities on which the principal has no permission do not appear. For more information, see Metadata Visibility Configuration.
The following example shows a list of all fixed database roles.
EXEC sp_helpdbfixedrole; GO