Transact-SQL Reference
sp_helpdbfixedrole
Returns a list of the fixed database roles.
Syntax
sp_helpdbfixedrole [ [ @rolename = ] 'role' ]
Arguments
[@rolename =] 'role'
Is the name of a fixed database role. role is sysname, with a default of NULL. If role is specified, only information about that role is returned; otherwise, a list and description of all fixed database roles is returned.
Return Code Values
0 (success) or 1 (failure)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| DbFixedRole | sysname | Name of the fixed database role. |
| Description | nvarchar(70) | Description of DbFixedRole. |
Remarks
Fixed database roles are defined at the database level and have permissions to perform specific database-level administrative activities. Fixed database roles cannot be added, removed, or changed.
| Fixed database role | Description |
|---|---|
| db_owner | Database owners |
| db_accessadmin | Database access administrators |
| db_securityadmin | Database security administrators |
| db_ddladmin | Database DDL administrators |
| db_backupoperator | Database backup operators |
| db_datareader | Database data readers |
| db_datawriter | Database data writers |
| db_denydatareader | Database deny data readers |
| db_denydatawriter | Database deny data writers |
The table shows stored procedures used for modifying database roles.
| Stored procedure | Action |
|---|---|
| sp_addrolemember | Adds a login account to a fixed database role. |
| sp_helprole | Displays a list of the members of a fixed database role. |
| sp_droprolemember | Removes a member from a fixed database role. |
Permissions
Execute permissions default to the public role.
Examples
This example shows a list of all fixed database roles.
EXEC sp_helpdbfixedrole