| title | Security Functions (Transact-SQL) | |||||
|---|---|---|---|---|---|---|
| description | Security Functions (Transact-SQL) | |||||
| author | VanMSFT | |||||
| ms.author | vanto | |||||
| ms.date | 03/15/2017 | |||||
| ms.service | sql | |||||
| ms.subservice | t-sql | |||||
| ms.topic | reference | |||||
| helpviewer_keywords |
|
|||||
| dev_langs |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
The following functions return information that is useful in managing security. Additional functions are listed under Cryptographic Functions (Transact-SQL).
:::row::: :::column::: CERTENCODED (Transact-SQL) :::column-end::: :::column::: PWDCOMPARE (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: CERTPRIVATEKEY (Transact-SQL) :::column-end::: :::column::: PWDENCRYPT (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_USER (Transact-SQL) :::column-end::: :::column::: SCHEMA_ID (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: DATABASE_PRINCIPAL_ID (Transact-SQL) :::column-end::: :::column::: SCHEMA_NAME (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: sys.fn_builtin_permissions (Transact-SQL) :::column-end::: :::column::: SESSION_USER (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: sys.fn_get_audit_file (Transact-SQL) :::column-end::: :::column::: SUSER_ID (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: sys.fn_my_permissions (Transact-SQL) :::column-end::: :::column::: SUSER_SID (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: HAS_PERMS_BY_NAME (Transact-SQL) :::column-end::: :::column::: SUSER_SNAME (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: IS_MEMBER (Transact-SQL) :::column-end::: :::column::: SYSTEM_USER (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: IS_ROLEMEMBER (Transact-SQL) :::column-end::: :::column::: SUSER_NAME (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: IS_SRVROLEMEMBER (Transact-SQL) :::column-end::: :::column::: USER_ID (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: LOGINPROPERTY (Transact-SQL) :::column-end::: :::column::: USER_NAME (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: ORIGINAL_LOGIN (Transact-SQL) :::column-end::: :::column::: :::column-end::: :::row-end::: :::row::: :::column::: PERMISSIONS (Transact-SQL) :::column-end::: :::column::: :::column-end::: :::row-end:::
For information about membership in Windows groups, see xp_logininfo (Transact-SQL) and xp_enumgroups (Transact-SQL).
Security Stored Procedures (Transact-SQL)
Cryptographic Functions (Transact-SQL)
Built-in Functions (Transact-SQL)
Security Statements