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 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Security and Protection

Identity and Access Control (Database Engine)

Permissions (Database Engine)

Permissions Hierarchy (Database Engine)

Catalog Views of Permissions (Database Engine)

Permissions of Fixed Database Roles (Database Engine)

Permissions of Fixed Server Roles (Database Engine)

Covering/Implied Permissions (Database Engine)

Minimize

This topic has not yet been rated - Rate this topic

Catalog Views of Permissions (Database Engine)

SQL Server 2008

Permissions information is made available by using catalog views that are optimized for performance and utility. The following catalog views return lists of explicit grants and denies.

Reference

Security Catalog Views (Transact-SQL)

Concepts

Permissions Hierarchy (Database Engine)

Securing SQL Server

Principals (Database Engine)

Permissions of Fixed Database Roles (Database Engine)

Permissions of Fixed Server Roles (Database Engine)

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.