security-functions-transact-sql.md

title	Security Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	sql-database
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	t-sql
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	functions [SQL Server], security security functions roles [SQL Server], functions users [SQL Server], security functions security [SQL Server], functions
ms.assetid	7773a87d-2f1b-4951-a225-baf159a7291b
caps.latest.revision	32
author	edmacauley
ms.author	edmaca
manager	craigg

Security Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

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