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.