Oracle Security in CDBs and PDBs - OCP: Oracle Database 12c Administrator Certified Professional - page 635

exeRCiSe 14.1 (continued)
SQL*Plus: Release 12.1.0.1.0 Production on Fri Nov 29 12:36:18 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
SQL> SHOW USER
USER is "SYS"
SQL> SHOW CON_NAME
CON_NAME
---------
CDB$ROOT
SQL>
4. Create a common user in the CDB$ROOT .
SQL> CREATE USER c##my_user
2 IDENTIFIED BY secret
3 DEFAULT TABLESPACE user_data
4 QUOTA 1G ON user_data
5 TEMPORARY TABLESPACE temp
6 CONTAINER = ALL;
User created.
SQL>
5. Attempt to create a local user in the CDB$ROOT . This will fail.
SQL> CREATE USER local_user
2 IDENTIFIED BY cgyoomm
3 DEFAULT TABLESPACE user_data
4 QUOTA 1G ON example
5 TEMPORARY TABLESPACE temp
6 CONTAINER = CURRENT;
IDENTIFIED BY cgyoomm
*
ERROR at line 2:
ORA-65049: creation of local user or role is not allowed in CDB$ROOT
SQL>