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