Which two actions should you perform in sequence?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The instance has a
Products table that is currently in the OevUser schema. The Appusers database role is
assigned Read and update permissions to the table.
The DevUser schema is owned by a database login that has been renamed. You need to
move the Products table from the DevUser schema to the dbo schema. Which two actions
should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The instance has a
Products table that is currently in the OevUser schema. The Appusers database role is
assigned Read and update permissions to the table.
The DevUser schema is owned by a database login that has been renamed. You need to
move the Products table from the DevUser schema to the dbo schema. Which two actions
should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)

Answer:

Explanation:

Note:
First transfer the table, then grant required permissions (which have been dropped by the
transfer).
All permissions associated with the securable will be dropped when the securable is moved
to the new schema.
Example: Transferring ownership of a table The following example modifies the schema
HumanResources by transferring the table Address from schema Person into the schema.
USE AdventureWorks2012; GO ALTER SCHEMA HumanResources TRANSFER
Person.Address; GO

ALTER SCHEMA (Transact-SQL)



Leave a Reply 0

Your email address will not be published. Required fields are marked *