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 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

Security Statements

ADD SIGNATURE (Transact-SQL)

CLOSE MASTER KEY (Transact-SQL)

CLOSE SYMMETRIC KEY (Transact-SQL)

DENY (Transact-SQL)

EXECUTE AS (Transact-SQL)

EXECUTE AS Clause (Transact-SQL)

GRANT (Transact-SQL)

OPEN MASTER KEY (Transact-SQL)

OPEN SYMMETRIC KEY (Transact-SQL)

REVERT (Transact-SQL)

REVOKE (Transact-SQL)

SETUSER (Transact-SQL)

Minimize

1 out of 1 rated this helpful - Rate this topic

Security Statements

SQL Server 2012

SQL Server 2008 R2

SQL Server provides the following security statements.

In This Section

ADD SIGNATURE	GRANT
CLOSE MASTER KEY	OPEN MASTER KEY
CLOSE SYMMETRIC KEY	OPEN SYMMETRIC KEY
DENY	REVERT
EXECUTE AS	REVOKE
EXECUTE AS Clause	SETUSER

Reference

Security Catalog Views (Transact-SQL)

Security Stored Procedures (Transact-SQL)

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

Security Functions (Transact-SQL)

Concepts

System Security Functions

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.