Multiple choice technology databases

CREATE USER sh IDENTIFIED BY sh; 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 sh WITH ADMIN OPTION; Which action the user SH cannot perform?

  1. Create and drop a materialized view

  2. Grant and revoke the role to and from other users

  3. Enable the role and exercise any privileges in the role's privilege domain

  4. Select from a table
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The user SH has been granted privileges to create/drop materialized views and dimensions, and can grant/revoke the dw_manager role with ADMIN OPTION. However, SH has not been granted SELECT privileges on any tables, so cannot select from tables (option D is correct - SH cannot perform this action).

Keep practicing — related questions