Database Administration (MOSC)

MOSC Banner

[19c EE] Lost privileges when created APPLICATION CONTAINER FROM PDB

edited Aug 12, 2021 11:59AM in Database Administration (MOSC) Question

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

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