Question:Evaluate the following SQL:

CREATE USER sam IDENTIFIED BY sam;
GRANT

CREATE ANY MATERIALIZED VIEW,
CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE
TO dw_manager
WITH ADMIN OPTION;
GRANT dw_manager TO sam WITH ADMIN OPTION;

Which of the following actions is the user SAM able to perform? 

A Select from a table 
B Create and drop a materialized view 
C Alter a materialized view that you created 
D Grant and revoke the role to and from other users 
E Enable the role and exercise any privileges in the role's privilege domain 

+ Answer
D 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description