Managing Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 557

e xeRCiSe 12.1 (continued)
OK (10 msec)
C:\>sqlplus system/system@CONT
SQL*Plus: Release 12.1.0.1.0 Production on Fri Nov 29 12:43:35 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 "SYSTEM"
SQL> SHOW CON_NAME
CON_NAME
---------
CDB$ROOT
SQL>
6. Since you're here, create a new common user, grant connect to the user, and then
connect to the CDB root as the user via the net service name:
SQL> CREATE USER c##cdbuser IDENTIFIED BY common
2 DEFAULT TABLESPACE users
3 QUOTA UNLIMITED ON users
4 CONTAINER = ALL;
User created.
SQL> GRANT CONNECT TO C##cdbuser;
Grant succeeded.
SQL> CONNECT c##cdbuser/common@CONT
Connected.
SQL> SHOW USER
USER is "C##CDBUSER"
SQL> SHOW CON_NAME
CON_NAME
---------
CDB$ROOT
SQL>