Security Functions (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

The following functions return information that is useful in managing security. Additional functions are listed under Cryptographic Functions (Transact-SQL).

CERTENCODED (Transact-SQL) PWDCOMPARE (Transact-SQL)
CERTPRIVATEKEY (Transact-SQL) PWDENCRYPT (Transact-SQL)
CURRENT_USER (Transact-SQL) SCHEMA_ID (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transact-SQL) SCHEMA_NAME (Transact-SQL)
sys.fn_builtin_permissions (Transact-SQL) SESSION_USER (Transact-SQL)
sys.fn_get_audit_file (Transact-SQL) SUSER_ID (Transact-SQL)
sys.fn_my_permissions (Transact-SQL) SUSER_SID (Transact-SQL)
HAS_PERMS_BY_NAME (Transact-SQL) SUSER_SNAME (Transact-SQL)
IS_MEMBER (Transact-SQL) SYSTEM_USER (Transact-SQL)
IS_ROLEMEMBER (Transact-SQL) SUSER_NAME (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL) USER_ID (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL) USER_NAME (Transact-SQL)
PERMISSIONS (Transact-SQL)

For information about membership in Windows groups, see xp_logininfo (Transact-SQL) and xp_enumgroups (Transact-SQL).

See Also

Security Stored Procedures (Transact-SQL)
Cryptographic Functions (Transact-SQL)
Built-in Functions (Transact-SQL)
Security Statements