What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
GRANT SELECT,INSERT,ALTER,UPDATE ON client TO shannon;
REVOKE INSERT ON client FROM 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 insert data in CLIENT

Question

Quizplus · Accepted Answer

The GRANT statement initially gives Shannon SELECT, INSERT, ALTER, and UPDATE permissions on the CLIENT table. However, the subsequent REVOKE statement removes the INSERT permission. Therefore, Shannon retains the ability to read data from CLIENT (SELECT), change data in CLIENT (UPDATE), and change the metadata of CLIENT (ALTER).

What Will Be the Outcome of the Following SQL Statements