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:
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



Leave a Reply 4

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


Ashwini

Ashwini

Answer is D: DELETE, INSERT, SELECT, UPDATE
Object privilege on VIEW are DELETE, INSERT, REFERENCES, SELECT and UPDATE.

Vishal

Vishal

Why not alter??