[19c EE] Lost privileges when created APPLICATION CONTAINER FROM PDB
Hi all
I am currently tried to create pluggable database as APPLICATION CONTAINER from an existing PDB, and i noticed that the "ADMIN USER" lost privileges.
Here is my test :
I have a PDB (call PDB_SRC) created with DBO as "admin user". This user have PDB_DBA role.
This user can, for example, create user or lock / unlock user
1 - I create a pluggable database from this PDB_SRC using :
create pluggable database PDB_TRG from PDB_SRC ;
alter pluggable database PDB_TRG open;
2 - i connect with DBO on PDB_TRG and i can do "ALTER USER test ACCOUNT LOCK;" - no problem