Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

Returns a list of the fixed database roles.


sp_helpdbfixedrole [ [ @rolename = ] 'role' ]


[@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.


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.


Execute permissions default to the public role.


This example shows a list of all fixed database roles.

EXEC sp_helpdbfixedrole

See Also






System Stored Procedures

© 2015 Microsoft