sp_helpdbfixedrole (T-SQL)

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

sp_addrolemember	sp_helprole
sp_dbfixedrolepermission	sp_helprolemember
sp_droprolemember	System Stored Procedures