What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
CREATE ROLE supervisor;
GRANT SELECT,INSERT,UPDATE ON client TO supervisor;
GRANT SUPERVISOR TO shannon;
A)Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT,insert data in CLIENT
B)Shannon can read data from CLIENT,change data in CLIENT,insert data in CLIENT
C)Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT
D)Shannon can change the metadata of CLIENT

Question

Quizplus · Accepted Answer

The first statement creates a new role called "supervisor". 
The second statement grants SELECT, INSERT, and UPDATE privileges on the "client" table to the "supervisor" role. 
The third statement grants the "supervisor" role to "shannon". Therefore, "shannon" can read data from, change data in, and insert data into the "client" table, but cannot change the metadata of the "client" table.

What Will Be the Outcome of the Following SQL Statements