The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command:GRANT ALL -ON orders,

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command:GRANT ALL -ON orders,

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply