You need to perform these tasks:
- Create and assign a MANAGER role to Blake and Clark
- Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark
Which set of SQL statements achieves the desired results?
A. CREATE ROLE manager;GRANT create table, create viewTO manager;GRANT manager TO BLAKE,CLARK;
B. CREATE ROLE manager;GRANT create table, create voewTO manager;GRANT manager ROLE TO BLAKE,CLARK;
C. GRANT manager ROLE TO BLAKE,CLARK;GRANT create table, create voewTO BLAKE CLARK;***MISSING***