SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELECTON oe. orders -TO mgr;3 - GRANT mgr, create table TO SCOTT;Which statement is true regarding the execution of the above commands?
A. Statement 1 would not execute because the WITH GRANT option is missing.
B. Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.
C. Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.
D. Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.
SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELE
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am