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

COUNT(1)
----------
6179
SQL> ALTER SESSION SET CONTAINER=lne6;
Session altered.
SQL> SELECT COUNT(1) FROM dba_views;
SELECT COUNT(1) FROM dba_VIEWS
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SELECT COUNT(1) FROM dba_tables;
COUNT(1)
----------
2336
SQL>
Managing Local Privileges
A local privilege is a privilege that applies only to the PDB in which it is granted. Local
privileges in a PDB are synonymous with privileges in a non-CDB. Privileges are applied to
a common user or local user and apply to local objects. For a locally granted privilege, the
following rules apply:
■ It can be used only in the container in which it was granted.
■ If granted in the CDB$ROOT , it applies only to the root.
■ Common users and local users can grant privileges locally to any other user or role,
including the PUBLIC role.
■ When granting a local privilege the user is connected to the current container and can
use the CONTAINER=CURRENT clause in the GRANT statement.
You can log onto the PDB and grant local privileges to a local user and also to common
users, as in this example:
SQL> CONNECT lne6_admin/system06@lne6
SQL> GRANT SELECT ON hr.countries TO lne_nd CONTAINER=CURRENT;