Query PDB from CDB .

Hi all

I am trying to run a query at PDB from CDB.

I created a user C##USER at the container and give this user the following.

ALTER USER C##USER SET CONTAINER_DATA=ALL CONTAINER=ALL;

GRANT SELECT_CATALOG_ROLE TO C##USER CONTAINER=ALL;

GRANT SET CONTAINER, CREATE SESSION TO C##USER CONTAINER=ALL;

I am getting the following errors:

SQL> ALTER SESSION SET CONTAINER=OR12PDB5;

ERROR:

ORA-65024: Pluggable database OR12PDB5 is not open.

SQL> ALTER SESSION SET CONTAINER=PDB$SEED;

ERROR:

ORA-01031: insufficient privileges

Please advice.

Eyal