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?

Question

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?

Accepted Answer

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

Answer

A. PUBLIC should be replaced with specific usernames.

Answer

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

Answer

C. WITH GRANT OPTION should be added to the 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…