Security Functions (Transact-SQL)

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

CURRENT_USER (Transact-SQL)

SETUSER (Transact-SQL)

sys.fn_builtin_permissions (Transact-SQL)

SUSER_ID (Transact-SQL)

Has_Perms_By_Name (Transact-SQL)

SUSER_SID (Transact-SQL)

IS_MEMBER (Transact-SQL)

SUSER_SNAME (Transact-SQL)

IS_SRVROLEMEMBER (Transact-SQL)

SYSTEM_USER (Transact-SQL)

PERMISSIONS (Transact-SQL)

SUSER_NAME (Transact-SQL)

SCHEMA_ID (Transact-SQL)

USER_ID (Transact-SQL)

SCHEMA_NAME (Transact-SQL)

USER_NAME (Transact-SQL)

SESSION_USER (Transact-SQL)

See Also

Reference

Security Stored Procedures (Transact-SQL)
Cryptographic Functions (Transact-SQL)
Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance