What correction needs to be done to the above statement?

The user SCOTT who is the owner of ORDERS and ORDERJTEMS 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 ORDERJTEMS 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.
Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

B.
PUBLIC should be replaced with specific usernames.

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

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



Leave a Reply 0

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