sp_helprotect [name [, username [, "grant" [,"none"|"granted"|"enabled"|role_name [,permission_name]]]]]
The value for permission_name can be any of the values from sysprotects.action.
This example executes sp_helprotect using the “Decrypt” action from sysprotects.action:
sp_helprotect @permission_name = 'Decrypt'
grantor grantee type action object column grantable ------- -------- ----- ------- ------- ------ --------- sa1 hr_login Grant Decrypt employee ssn TRUE sa1 hr_role Grant Decrypt employee ssn FALSE
Any user can run sp_helprotect to view his or her permission information. Only the SSO can view permissions for all users.
