fn_builtin_permissions

Returns a description of the built in permissions hierarchy of the server. fn_builtin_permissions returns all permissions.

Syntax

fn_builtin_permissions ( )

Tables Returned

fn_builtin_permissions returns the following information.

Column name Data type Description
class_desc nvarchar(60) Description of the securable class.
permission_name nvarchar(60) Permission name.
type varchar(4) Compact permission type code.
covering_permission_name nvarchar(60) If not NULL, this is the name of the permission on this class that implies the other permissions on this class.
parent_class_desc nvarchar(60) If not NULL, this is the name of the parent class that contains the current class.
parent_covering_permission_name nvarchar(60) If not NULL, this is the name of the permission on the parent class that implies all other permissions on that class.

Example

select *
  from fn_builtin_permissions();

See Also