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.
PUBLIC should be replaced with specific usernames.

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

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

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



Leave a Reply 4

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


user

user

grant all on empu to public;
grant all on emp, empu to public;

user

user

GRANT ALL ON orders, emp TO hr;

user

user

grant all on empu, empu to public;
grant select on empu, update on empu to role_one;
grant select on empu, empu to role_one;
grant select on empu, create table to role_one;

grant create synonym, select on emp to role_one;
grant select, update, delete on emp to public;