View the Exhibit and examine the privileges granted to the MGR_ROLE role.The user SKD has been granted the CONNECT and R

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

View the Exhibit and examine the privileges granted to the MGR_ROLE role.The user SKD has been granted the CONNECT and R

Post by answerhappygod »

View the Exhibit and examine the privileges granted to the MGR_ROLE role.The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;Which statement is true about the user SKD after he/she is granted this role?Exhibit:
View The Exhibi 1
View The Exhibi 1 (70.14 KiB) Viewed 145 times
A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it
B. The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor
C. The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION
D. The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them
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