Home Library Learn Downloads Support Community
Sign in | United States - English | |
3 out of 21 rated this helpful - Rate this topic

Securables

SQL Server 2005

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.

Contains the following securables:

  • Endpoint
  • Login
  • 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

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
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Error

(duplicate post)

History
Constraints and Statistics are not securables
Remove Constraint and Statistic from the list of securables. Just like Indexes, these cannot have permissions assigned to them.
History