You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those…

The correct answer is D. GRANT select, insert, update. 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 A: This statement would be correct if it included WITH GRANT OPTION clause…

Controlling User Access

Question

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?

Options

AGRANT select, insert, update
BGRANT select, insert, update
CGRANT select, insert, modify
DGRANT select, insert, update
EGRANT select, insert, update
FF.GRANT select, insert, modify

How the community answered

(19 responses)

B
11% (2)
C
5% (1)
D
79% (15)
E
5% (1)

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 A: This statement would be correct if it included WITH GRANT OPTION clause to allow this role to pass those privileges on to others. B: This statement uses incorrect clause TO ROLE. C: There is no option with name MODIFY in the GRANT command. E: This statement uses incorrect clause TO ROLE. F: There is no option with name MODIFY in the GRANT command. And this statement also uses incorrect clause TO ROLE.

Topics

#GRANT#role privileges#WITH ADMIN OPTION#DML privileges

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice