United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

Built-in Functions (Transact-SQL)

Security Functions (Transact-SQL)

CURRENT_USER (Transact-SQL)

HAS_DBACCESS (Transact-SQL)

HAS_PERMS_BY_NAME (Transact-SQL)

HASHBYTES (Transact-SQL)

IS_MEMBER (Transact-SQL)

IS_SRVROLEMEMBER (Transact-SQL)

LOGINPROPERTY (Transact-SQL)

ORIGINAL_LOGIN (Transact-SQL)

PERMISSIONS (Transact-SQL)

PWDENCRYPT (Transact-SQL)

PWDCOMPARE (Transact-SQL)

SESSION_USER (Transact-SQL)

SESSIONPROPERTY (Transact-SQL)

SUSER_ID (Transact-SQL)

SUSER_NAME (Transact-SQL)

SUSER_SID (Transact-SQL)

SUSER_SNAME (Transact-SQL)

SYSTEM_USER (Transact-SQL)

USER (Transact-SQL)

USER_ID (Transact-SQL)

USER_NAME (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

Security Functions (Transact-SQL)

SQL Server 2008 R2

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

For information about Windows groups that have logins, see xp_logininfo (Transact-SQL) and xp_enumgroups (Transact-SQL).

Reference

Security Stored Procedures (Transact-SQL)

Cryptographic Functions (Transact-SQL)

Built-in Functions (Transact-SQL)

Security-Related Dynamic Management Views and Functions (Transact-SQL)

Security Catalog Views (Transact-SQL)

Concepts

Security Statements

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.