Sunday, December 15, 2013

Multitenant Self-Service Provisioning - BETA 2 - Started to play

Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb.
(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;

    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
*** Created PDB ***
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';

    CON_ID USERNAME
---------- ---------------------------------------------------
         3 PDB_ADMIN
Oops!
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: