|
Explanation: This answer provides correct syntax of GRANT command to give the MANAGER role all asked privileges. Clause WITH GRANT OPTION will allow this role to pass those privileges on to others. Incorrect Answers: 1: This statement would be correct if it included WITH GRANT OPTION clause to allow this role to pass those privileges on to others. 2: This statement uses incorrect clause TO ROLE. 3: There is no option with name MODIFY in the GRANT command. 5: This statement uses incorrect clause TO ROLE. 6: There is no option with name MODIFY in the GRANT command. And this statement also uses incorrect clause TO ROLE. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365 Chapter 8: User Access Control in Oracle
|