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 ROLE registrar; GRANT MODIFY ON student_grades TO registrar;
GRANT registrar to user1, user2, user3
B.
CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar;
GRANT registrar to user1, user2, user3
C.
CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar;
GRANT ROLE registrar to user1, user2, user3
D.
CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar;
GRANT registrar to user1, user2, user3;
E.
CREATE registrar; GRANT CHANGE ON student_grades TO registrar;
GRANT registrar;
Explanation:
this is the correct solution for the answer.
GRANT role_name to users;
Incorrect answer:
Athere is no such MODIFY keyword
Binvalid CREATE command, there is no such NEW keyword
Cinvalid GRANT command, there is no such ROLE keyword
Einvalid GRANT command, there is no such CHANGE keyword