sys.sp_helprotect

Description

Returns a report that’s information about user permissions for an object, or statement permissions, in the current database. Doesn’t list permissions that are always assigned to the fixed server roles or fixed database roles.

Syntax

sp_helprotect
[ [ @name = ]
N
'name'
]
[ , [ @username = ]
N
'username'
]
[ , [ @grantorname = ]
N
'grantorname'
]
[ , [ @permissionarea = ]
'permissionarea'
]
[ ; ]

Examples

Example 1

sp_helprotect

Example 2

sp_helprolemember

Example 3

EXECUTE sp_helprole;

Example 4

CREATE TABLE

Example 5

EXECUTE sp_helprotect @
name
=
'CREATE TABLE'
;