You are the DBA for an academic database. You need to create a role that allows a group
of users to modify existing rows in the STUDENT_GRADES table. Which set of statements
accomplishes this?
A.
CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT
registrar to user1, user2, user3
B.
CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;
C.
CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT
ROLE registrar to user1, user2, user3
D.
CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT
registrar to user1, user2, user3
E.
CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT
registrar to user1, user2, user3;
Explanation: