SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

Functions (Transact-SQL)

Aggregate Functions (Transact-SQL)

Configuration Functions (Transact-SQL)

Cryptographic Functions (Transact-SQL)

Cursor Functions (Transact-SQL)

Date and Time Functions (Transact-SQL)

Mathematical Functions (Transact-SQL)

Metadata Functions (Transact-SQL)

Ranking Functions (Transact-SQL)

Replication Functions (Transact-SQL)

Rowset Functions (Transact-SQL)

Security Functions (Transact-SQL)

String Functions (Transact-SQL)

System Functions (Transact-SQL)

System Statistical Functions (Transact-SQL)

Text and Image Functions (Transact-SQL)

Minimize

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)

Reference

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

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.