1

Topic: How to learn the list connected to basis PDB

In command ALTER USER is container_data_clause where it is necessary to inscribe container_name.
1. At me to a DB it is connected PDB. I it know a name and I can use in ALTER USER. And if would not know how to learn, what are connected?

SELECT * FROM dba_pdbs

Gives an empty data set sad
2. In docks is For every DBA_* view, a CDB_* view is defined.
However any attempt of request with CDB _ instead of DBA _ gives an error:

ORA-01435: user does not exist

And how it to understand?
And in both cases at the user role DBA and SELECT_CATALOG_ROLE.

2

Re: How to learn the list connected to basis PDB

Vasja wrote:

And how it to understand?

As usual in your case - to smoke to dock ( Enabling Common Users to View CONTAINER_DATA Object Information ):

SQL> create user c##common identified by common container = all;
User created.
SQL> grant create session to c##common container = all;
Grant succeeded.
SQL> grant select on dba_pdbs to c##common container = all;
Grant succeeded.
SQL> grant select on cdb_pdbs to c##common container = all;
Grant succeeded.
SQL> connect c##common@sol122/common
Connected.
SQL> select pdb_name from dba_pdbs;
no rows selected
SQL> select pdb_name from cdb_pdbs;
no rows selected
SQL> connect / @sol122 as sysdba
Connected.
==> SQL> alter user c##common set container_data=all container=current;
User altered.
SQL> connect c##common@sol122/common
Connected.
SQL> select pdb_name from dba_pdbs;
PDB_NAME
--------------------------------------------------------------------------------
PDB1SOL122
PDB$SEED
SQL> select pdb_name from cdb_pdbs;
PDB_NAME
--------------------------------------------------------------------------------
PDB1SOL122
PDB$SEED
SQL>

SY.

3

Re: How to learn the list connected to basis PDB

SQL> show pdbs smile