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.....