sys.sp_dbfixedrolepermission

Description

Displays the permissions of a fixed database role. information in SQL Server 2000 (8.x). The output doesn’t reflect the changes to the permissions hierarchy that were implemented in SQL Server 2005 (9.x). For more information, see , which shows a list of fixed database roles and its corresponding permissions.

Syntax

sp_dbfixedrolepermission

Examples

Example 1

EXECUTE sp_dbfixedrolepermission;
GO

Example 2

sp_revokelogin
DROP LOGIN

Example 3

sp_srvrolepermission sp_dbfixedrolepermission

Example 4

sp_srvrolepermission sp_dbfixedrolepermissio

Example 5

GRANT ALL
DENY ALL
REVOKE ALL
GRANT

Example 6

DENY

Example 7

REVOKE

Example 8

sys.fn_my_permissions

Example 9

EXECUTE AS

Example 10

DESX

(. and 15 more examples)