Database Administration (MOSC)

MOSC Banner

Why "SET CONTAINER" system privilege does not work ?

edited Dec 8, 2013 11:47PM in Database Administration (MOSC) 2 commentsAnswered
## I connect to a pdb named orapdbb with user b_admin who has been granted the "PDB_DBA" role
SQL> show con_name

CON_NAME
------------------------------
ORAPDBB
SQL> show user
USER is "B_ADMIN"
SQL> select * from dba_sys_privs where grantee='B_ADMIN';

GRANTEE
--------------------------------------------------------------------------------
PRIVILEGE                                ADM COM
---------------------------------------- --- ---
B_ADMIN
SELECT ANY DICTIONARY                    NO  NO


SQL> select * from dba_role_privs where grantee='B_ADMIN';

GRANTEE
--------------------------------------------------------------------------------
GRANTED_ROLE
--------------------------------------------------------------------------------
ADM DEF COM
--- --- ---
B_ADMIN
PDB_DBA
YES YES NO

## The "PDB_DBA" role has a privilege called "SET CONTAINER"
SQL> select * from dba_sys_privs where grantee='PDB_DBA';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center