The purpose of creating a local admin user for the pdb
We create a pluggable database with the following command in SQL*PLUS:
CREATE PLUGGABLE DATABASE pdb3 ADMIN USER pdb3_admin IDENTIFIED BY oracle ROLES=(CONNECT) FILE_NAME_CONVERT=('+DATA/pdb$seed_', '+DATA/pdb3/','+DATA/pdbseed_','+DATA/pdb3/');
CREATE PLUGGABLE DATABASE pdb3 ADMIN USER pdb3_admin IDENTIFIED BY oracle ROLES=(CONNECT) FILE_NAME_CONVERT=('+DATA/pdb$seed_', '+DATA/pdb3/','+DATA/pdbseed_','+DATA/pdb3/');
The pdb3_admin is created for doing some administrative tasks in the pdb.
Now I have a question ,since every pdb has SYS and SYSTEM user, these two users are enough to do all administrative tasks.
So why should we define another local admin user for the pdb ?
0