Permissions (Database Engine)
http://msdn.microsoft.com/en-us/library/ms191291.aspx
The following table lists major classes of permissions and the kinds of securables to which they may be applied.
| Permission | Applies to |
|---|---|
| SELECT | Synonyms
Tables and columns Table-valued functions, Transact-SQL and common language runtime (CLR), and columns Views and columns |
| VIEW CHANGE TRACKING | Tables
Schemas |
| UPDATE | Synonyms
Tables and columns Views and columns |
| REFERENCES | Scalar and aggregate functions (Transact-SQL and CLR)
Service Broker queues Tables and columns Table-valued functions (Transact-SQL and CLR), and columns Views and columns |
| INSERT | Synonyms
Tables and columns Views and columns |
| DELETE | Synonyms
Tables and columns Views and columns |
| EXECUTE | Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR) Synonyms CLR types |
| RECEIVE | Service Broker queues |
| VIEW DEFINITION | Procedures (Transact-SQL and CLR)
Service Broker queues Scalar and aggregate functions (Transact-SQL and CLR) Synonyms Tables Table-valued functions (Transact-SQL and CLR) Views |
| ALTER | Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR) Service Broker queues Tables Table-valued functions (Transact-SQL and CLR) Views |
| TAKE OWNERSHIP | Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR) Synonyms Tables Table-valued functions (Transact-SQL and CLR) Views |
| CONTROL | Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR) Service Broker queues Synonyms Tables Table-valued functions (Transact-SQL and CLR) Views |
