What privilege is required to create a view on a table that you are not the owner of?
A.
INSERT
B.
SELECT
C.
CREATE
D.
TRIGGER
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
B)
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000935.html
and at least one of the following authorities for each table, view, or nickname identified in any fullselect:
– CONTROL privilege on that table, view, or nickname
– SELECT privilege on that table, view, or nickname
– DATAACCESS authority
0
0