Which object privileges can be granted on a view?
A.
none
B.
DELETE, INSERT,SELECT
C.
ALTER, DELETE, INSERT, SELECT
D.
DELETE, INSERT, SELECT, UPDATE
Explanation:
Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and
UPDATE.
Incorrect answer:
AObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
BObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
CObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-12
Answer is D: DELETE, INSERT, SELECT, UPDATE
Object privilege on VIEW are DELETE, INSERT, REFERENCES, SELECT and UPDATE.
Why not alter??
Maybe C is correct too
Alter is a System Privillage, look here
https://docs.oracle.com/cd/E21901_01/timesten.1122/e21642/privileges.htm#TTSQL339