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