What correction needs to be done to the above statement?

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the
following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What
correction needs to be done to the above statement?

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the
following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What
correction needs to be done to the above statement?

A.
WITH GRANT OPTION should be added to the statement.

B.
Separate GRANT statements are required for ORDERS and ORDER_ITEMS tables.

C.
ALL should be replaced with a list of specific privileges.

D.
PUBLIC should be replaced with specific usernames.



Leave a Reply 0

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