Which object privileges can be granted on a view?

Which object privileges can be granted on a view?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *