DRAG DROP
You administer a Microsoft SQL Server 2008 R2 server that hosts two databases named
NorthwindOLTP and NorthwindOLAP. Cross database ownership chaining is currently
disabled for all databases.
A stored procedure in the NorthwindOLTP database writes data to a table in the
NorthwindOLAP database. The public role in both databases has only Read and Execute
permissions assigned to all objects. All objects are located in the DBO schema. Guest
access has been disabled for all databases on the server.
You need to ensure that the stored procedure can execute successfully.
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.)
Note:
* Cross database ownership chaining can be turned on at either the server or the database
level. If cross database ownership chaining is on at the server level, it is on for all databaseon that server, regardless of what the individual database settings are. By default, cross
database ownership chaining is turned off at the server level and it is off on all databases
except the following:
master msdb tempdb These three system databases require cross-database ownership
chaining to be turned on. Outside of these three, the general rules, due to security
implications, are:
Cross database ownership chaining should not be turned on at the server level. It should
only be turned on for databases which require it.