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

FROM cdb_users
*
ERROR at line 2:
ORA-00942: table or view does not exist]
SQL>
…
USERNAME CON_ID
-------------------- ----------
XDB 1
3
6
XS$NULL 1
3
6
local_sample 6
122 rows selected.
SQL>
Summary
In this chapter, you learned about Oracle Database 12 c security and specifically how to
manage security in a CDB and PDBs. You learned how to manage common and local users,
common and local privileges, and common and local roles and how to enable common
users to access data in PDBs.
The first topic was about managing common and local users in the multitenant environment.
In this chapter, we expanded on what you learned in previous chapters and demonstrated how
to manage users in the multitenant environment. You learned that common users are defined in
the CDB$ROOT and have the same identity across all PDBs in the CDB. You learned that all user-
created common users must have a username that begins with c## or C## and that when you
create the user, you specify CONTAINER=ALL . You cannot create a common user when the current
container is a PDB. You learned that local users are specific to a PDB, that they must be unique
within a PDB, and that a local username can be repeated across PDBs but that each occurrence
of the local username is independent of any other local user with the same name within the
same CDB. A local username may not begin with c## or C## .
Next, we discussed common and local privileges. A user privilege is the authority or
right to run a PL/SQL package, issue a particular type of SQL statement, or access an object
that belongs to another user. Privileges can be granted to common or local users. Privileges