Database Administration (MOSC)

MOSC Banner

Can I created a common users in the cdb with a table and this table can be see in the pdb?

Oracle 19c Multitenant

Exemple:

CREATE USER c##VDMSYS

  IDENTIFIED BY mypassword

  DEFAULT TABLESPACE USERS

  QUOTA UNLIMITED ON USERS

  TEMPORARY TABLESPACE temp;

 

GRANT CREATE SESSION TO c##VDMSYS;


CREATE TABLE c##VDMSYS.USAGERS

(

 USAGER   VARCHAR2(30 BYTE)         NOT NULL,

 SQL_VERIF VARCHAR2(3500 BYTE)        NOT NULL

);




SQL> show pdbs


  CON_ID CON_NAME            OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

     2 PDB$SEED            READ ONLY NO

     3 PDB_GEOMATIQUE       READ WRITE NO



ALTER SESSION SET CONTAINER=PDB_GEOMATIQUE;


THEN


SELECT * FROM c##VDMSYS.USAGERS;


Is this possible?


Because doesn't work for me.....

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center