Database Administration (MOSC)

MOSC Banner

Desire to know more about the container_data attribute of a common user

edited Dec 13, 2013 10:13PM in Database Administration (MOSC) 2 commentsAnswered
The "set container_data" clause of alter user can be used to control which pdb's information being visible to a common user.
Be interested in it,I do some tests to verify its function. My tests is composed of two independent tests and I have some questions about my tests. My question is in bold and big fonts.

---My testing environment has 2 active pdbs: orapdba & orapdbb
SQL> select * from v$pdbs;

    CON_ID       DBID    CON_UID GUID                             NAME                           OPEN_MODE  RES
---------- ---------- ---------- -------------------------------- ------------------------------ ---------- ---
OPEN_TIME                                                                   CREATE_SCN TOTAL_SIZE
--------------------------------------------------------------------------- ---------- ----------
         2 4071385469 4071385469 E8B486756A607BCAE0436438A8C029D2 PDB$SEED                       READ ONLY  NO

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