Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Translates the permissions bitmask returned by SQL Trace into a table of permissions names.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sys.fn_translate_permissions ( level , perms )
Arguments
level
Is the kind of securable to which the permission is applied. level is nvarchar(60).perms
Is a bitmask that is returned in the permissions column. perms is varbinary(16).
Returns
table
Remarks
The value returned in the permissions column of a SQL Trace is an integer representation of a bitmask used by SQL Server to calculate effective permissions. Each of the 21 kinds of securables has its own set of permissions with corresponding numerical values. sys.fn_translate_permissions translates this bitmask into a table of permissions names.
Permissions
Requires membership in the public role.
See Also
Reference
sys.server_permissions (Transact-SQL)
sys.database_permissions (Transact-SQL)