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
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)