Function |
Description |
CURRENT_USER |
Returns the name of the current user. This function is equivalent to USER_NAME().
Syntax:
CURRENT_USER
|
sys.fn_builtin_permissions |
Returns a description of the built-in permissions hierarchy of the server.
Syntax:
sys.fn_builtin_permissions ( [ DEFAULT | NULL ] | <empty_string> |
'<securable_class>' )
|
fn_my_permissions |
Returns a list of the permissions effectively granted to the principal on a securable. A related function is HAS_PERMS_BY_NAME.
Syntax:
fn_my_permissions ( <securable>, '<securable_class>' )
|
HAS_PERMS_BY_NAME |
Evaluates the effective permission of the current user on a securable. A related function is fn_my_permissions.
Syntax:
HAS_PERMS_BY_NAME ( <securable>, <securable_class> <permission>
[ , <sub-securable> ] [ , <sub-securatble_class> ] )
|
IS_MEMBER |
Indicates whether the current user is a member of the specified Microsoft Windows group or Microsoft SQL Server database role.
Syntax:
IS_MEMBER ( { '<group>' | '<role>' } )
|
IS_SRVROLEMEMBER |
Indicates whether a SQL Server login is a member of the specified fixed server role.
Syntax:
IS_SRVROLEMEMBER ( '<role>' [ , '<login>' ] )
|
PERMISSIONS |
Returns a value containing a bitmap that indicates the statement, object or column permissions of the current user.
Syntax:
PERMISSIONS ( [ <objectid> [ , '<column>' ] ] )
|
SCHEMA_ID |
Returns the schema ID associated with a schema name.
Syntax:
SCHEMA_ID ( [ <schema_name> ] )
|
SCHEMA_NAME |
Returns the schema name associated with a schema ID.
Syntax:
SCHEMA_NAME ( [ <schema_id> ] )
|