Security Functions (Transact-SQL)

Security Functions (Transact-SQL)

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Other versions are also available for the following:

SQL Server 2008 Books Online (June 2009)

Security Functions (Transact-SQL)

Updated: 28 May 2009

The following functions return information that is useful in managing security.

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

Change History

Updated content
Added ORIGINAL_LOGIN.
Added PWDCOMPARE and PWDENCRYPT.