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:
A:
Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
B:
Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
C:
Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-12
Alter is a system privilege
https://docs.oracle.com/cd/E21901_01/timesten.1122/e21642/privileges.htm#TTSQL339