:::: MENU ::::

Securables in SQL Server 2005

  • Oct 30 / 2008
  • 0
dbDigger, Logins and Users, Security and Permissions

Securables in SQL Server 2005

Database objects aren’t the only things that you can secure. You can create rights and privileges for everything from the server itself to each database and each object that they contain. Securables in SQL Server 2005 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. You can secure at server level, database level and schema level. The securable scopes are

  • server
  • database
  • schema

Securable scope Server contains following securables on SQL Server 2005

  • Endpoint
  • Login
  • Database

Securable scope database contains the following securables on SQL Server 2005

  • 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 on SQL Server 2005

  • Type
  • XML Schema Collection
  • Object

SQL Server Objects
The following securables are members of the object class for SQL Server 2005

  • Aggregate
  • Constraint
  • Function
  • Procedure
  • Queue
  • Statistic
  • Synonym
  • Table
  • View
Consult us to explore the Databases. Contact us