1 out of 1 rated this helpful - Rate this topic

Security Functions (Transact-SQL)

SQL Server 2005

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)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ