Which SQL statement accomplishes this?

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement
accomplishes this?

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement
accomplishes this?

A.
GRANT select ON dept
TO ALL_USERS;

B.
GRANT select ON dept
TO ALL;

C.
GRANT QUERY ON dept
TO ALL_USERS

D.
GRANT select ON dept
TO PUBLIC;

Explanation:
view the columns associated with the constraint names in the USER_CONS_COLUMNS view.
Incorrect answer:
A table to view all constraints definition and names
B show all object name belong to user
C does not display column associated
E no such view
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25

Show Hint

Leave a Reply 1

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

_reader_

_reader_

In my humble opinion: none of following is correct
correct answer is: GRANT READ ON DEPT TO PUBLIC;
but from following only GRANT SELECT ON DEPT TO PUBLIC (add SELECT, SELECT FOR UPDATE privilege) of course, correct statement (semantically) is D.

Reply