SQL Server 2008 Books Online (October 2009)
Securables

Securables are the resources to which the SQL Server Database Engine authorization system regulates access. Some securables can be contained within others, creating nested hierarchies called "scopes" that can themselves be secured. The securable scopes are server, database, and schema.

Securable scope: Server

Contains the following securables:

  • Endpoint
  • Login
  • Database
Securable scope: Database

Contains the following securables:

  • User
  • Role
  • Application role
  • Assembly
  • Message Type
  • Route
  • Service
  • Remote Service Binding
  • Fulltext Catalog
  • Certificate
  • Asymmetric Key
  • Symmetric Key
  • Contract
  • Schema
Securable scope: Schema

Contains the following securables:

  • Type
  • XML Schema Collection
  • Object

Objects

The following are members of the object class:

  • Aggregate
  • Constraint
  • Function
  • Procedure
  • Queue
  • Statistic
  • Synonym
  • Table
  • View
See Also

Concepts

Schemas (Database Engine)
Securing Data and Log Files
Ownership Chains
Securing SQL Server

Other Resources

sys.database_principals (Transact-SQL)
sys.database_role_members (Transact-SQL)
sys.server_principals (Transact-SQL)
sys.server_role_members (Transact-SQL)
sys.sql_logins (Transact-SQL)

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Community Content

CraigBeere
Constraints and Statistics are not securables
Remove Constraint and Securable from the list of securables. Just like Indexes, these cannot have permissions assigned to them.
Tags : error

Page view tracker