Security Functions in SQL Server 2005

Lists the functions that return information that is useful in managing security

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)
• sys.fn_builtin_permissions (Transact-SQL)
• PERMISSIONS (Transact-SQL)
• SYSTEM_USER (Transact-SQL)
• SCHEMA_ID (Transact-SQL)
• SUSER_NAME (Transact-SQL)
• SCHEMA_NAME (Transact-SQL)
• USER_ID (Transact-SQL)
• SESSION_USER (Transact-SQL)
• USER_NAME (Transact-SQL)