The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command:GRANT ALL -ON orders,
Posted: Wed Jun 07, 2023 6:11 am
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. 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 ORDERJTEMS tables.
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 ORDERJTEMS tables.