JOSE HAS OWNERSHIP OF DATABASE TABLES IN DATABASE A AND DATABASE B...

14. Jose has ownership of database tables in database A and database B, both of which

reside in the same instance of SQL Server where cross database ownership

chaining has been enabled. Jose uses a database view in database A to join both

tables in order to retrieve the needed data. Jose grants Jack permission to use

her database view. What other permissions need to be granted in order for Jack

to retrieve data using Jose’s view?

A. Jack needs to be granted read permissions to the table in database B that is

used by the view.

B. Since cross database ownership chaining is enabled in this instance, no

additional permissions need to be granted.

C. The tables used by the view in database A and B need read permissions

granted to Jack.

D. Jack cannot use Jose’s view since she is the owner. Jack will need his own

view and permissions.

The correct answer is B. With cross database ownership chaining, credentials

are only checked on the first object request. Since Jack was granted permission

by the object’s owner, Jose’s credentials will be used to access the tables in

database B. Answer A is incorrect since Jack was granted permission to the

view by the object owner and cross database ownership chaining was enabled.

Jack’s credentials would not be checked for accessing the table in database B.

In addition, there is no need to permission the database B table to Jack.

Answer C is incorrect since with cross database ownership chaining it is not

necessary for the object’s owner to grant permission on the view in database A

to Jack. Answer D is incorrect since Jose granted the view to Jack. The view

uses Jose’s credentials when it is run.