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.
Bạn đang xem 14. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P146 PPS