VOOZH about

URL: https://learn.microsoft.com/en-us/sql/t-sql/functions/security-functions-transact-sql?view=sql-server-ver17

⇱ Security Functions (Transact-SQL) - SQL Server | Microsoft Learn



Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Security Functions (Transact-SQL)

Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Managed Instance

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)

LOGINPROPERTY (Transact-SQL)

USER_NAME (Transact-SQL)

ORIGINAL_LOGIN (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


Feedback

Was this page helpful?


Additional resources


  • Last updated on