Which set of SQL statements achieves the desired results?

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?

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 view
TO manager;
GRANT manager TO BLAKE,CLARK;

B.
CREATE ROLE manager;
GRANT create table, create voew
TO manager;
GRANT manager ROLE TO BLAKE,CLARK;

C.
GRANT manager ROLE TO BLAKE,CLARK;
GRANT create table, create voew
TO BLAKE CLARK;

Explanation:
Result of commands:



Leave a Reply 0

Your email address will not be published. Required fields are marked *