SQL Server Security Functions
Security functions return information about users and roles. Security functions return information that is userful in managing security.
Tags: SQL Server String Functions SQL SQL Server Functions. Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables. SQL Server Date and Time Functions SQL Server Configuration Functions SQL Server Aggregate Functions SQL Server Metadata Functions SQL Server Security Functions SQL Server Mathematical Functions SQL Server System Functions.
Security functions return information about users and roles. Security functions return information that is userful in managing security.
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> ] ) |
SESSION_USER | Returns the user name of the current context in the current database.
Syntax:
SESSION_USER |
SETUSER | Allows a member of the sysadmin fixed server role of db_owner fixed database role to impersonate another user.
Syntax:
SETUSER [ '<username>' [ WITH NORESET ] ] |
SUSER_ID | Returns the login identification number of the user.
Syntax:
SUSER_ID ( [ '<login>' ] ) |
SUSER_SID | Returns the security identification number (SID) for the specified login name.
Syntax:
SUSER_SID ( [ '<login>' ] ) |
SUSER_SNAME | Returns the login name associated with a security identification number (SID).
Syntax:
SUSER_SNAME ( [ <server_user_id> ] ) |
SYSTEM_USER | Allows a system-supplied value for the current login to be inserted into a table when no default value is specified.
Syntax:
SYSTEM_USER |
SUSER_NAME | Returns the login identification name of the user.
Syntax:
SUSER_NAME ( [ <server_user_id> ] ) |
USER_ID | Returns the identification number for a database user.
Syntax:
USER_ID ( [ '<user>' ] ) |
USER_NAME | Returns a database user name from a specified identification number.
Syntax:
USER_NAME ( [ '<id>' ] ) |