(Downloaded pdbss_1030.zip and installed)
This version, the Oracle Multitenant Self-Service Provisioning application now runs in CDB$ROOT instead of a PDB.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
... some.. The PDB_ADMIN user in newly created PDBs has SYSDBA system privilege so it can fully manage the PDB.
SQL> select con_id, name, open_mode from v$pdbs;*** Created PDB ***
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
SQL> select con_id, username from cdb_users where username ='PDB_ADMIN';
no rows selected
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB1 READ WRITE
SQL> select con_id, username from cdb_users where username ='PDB_ADMIN';Oops!
CON_ID USERNAME
---------- ---------------------------------------------------
3 PDB_ADMIN
SQL> SELECT * FROM V$PWFILE_USERS;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SYSDG FALSE FALSE FALSE FALSE TRUE FALSE 1
SYSBACKUP FALSE FALSE FALSE TRUE FALSE FALSE 1
SYSKM FALSE FALSE FALSE FALSE FALSE TRUE 1
C##PDBMGR TRUE FALSE FALSE FALSE FALSE FALSE 0
PDB_ADMIN TRUE FALSE FALSE FALSE FALSE FALSE 3
6 rows selected.
No comments:
Post a Comment