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.