| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Security Functions (Transact-SQL) |
Security Functions (Transact-SQL) |
VanMSFT |
vanto |
03/15/2017 |
sql |
t-sql |
reference |
|
|
[!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