Page 94 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes ALTER ANY <Database Securable>, where Database Securable can be any securable
at the database level.
Confers the ability to CREATE, ALTER, or DROP individual instances of the Database
Securable. For example, ALTER ANY SCHEMA confers the ability to create, alter, or
drop any schema in the database.

TAKE OWNERSHIP: Enables the grantee to take ownership of the securable on which it is
granted.
IMPERSONATE <Login>

Enables the grantee to impersonate the login.
IMPERSONATE <User>
Enables the grantee to impersonate the user.
CREATE <Server Securable>

Confers to the grantee the ability to create the Server Securable.
CREATE <Database Securable>
Confers to the grantee the ability to create the Database Securable.
CREATE <Schema-contained Securable>

Confers the ability to create the schema-contained securable. However, ALTER permission
on the schema is required to create the securable in a particular schema.

VIEW DEFINITION: Enables the grantee to access metadata.
REFERENCES: The REFERENCES permission on a table is needed to create a FOREIGN
KEY constraint that references that table.
The REFERENCES permission is needed on an object to create a FUNCTION or VIEW with
the WITH SCHEMABINDING clause that references that object.

6.2.1 Permissions Applicable to Specific Securables

The following table lists major classes of permissions and the kinds of securables to which they
may be applied.
Table 6.1

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 Tables
TRACKING Schemas

UPDATE Synonyms
Tables and columns
Views and columns
REFERENCES Scalar and aggregate functions (Transact-SQL and CLR)
Service Broker queues
Contd....

88 LOVELY PROFESSIONAL UNIVERSITY