I'm creating a script and I need to know what is the admin user of pluggable database. I don't find nothing about it in documentation.
Other question is, what happen if I drop a admin user of the pluggable database? is there some problem?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Use this clause to create an administrative user who can be granted the privileges required to perform administrative tasks on the PDB. For admin_user_name, specify name of the user to be created. Use the IDENTIFIED BY clause to specify the password for admin_user_name. Oracle Database creates a local user in the PDB and grants the PDB_DBA local role to that user.
The admin user is just a local user with the PDB_DBA role. Example:
SQL> CREATE PLUGGABLE DATABASE mypdb ADMIN USER balazs IDENTIFIED BY Oracle123 FILE_NAME_CONVERT=('pdbseed','mypdb'); Pluggable database created. SQL> alter pluggable database mypdb open; Pluggable database altered. SQL> select grantee from cdb_role_privs where con_id = (select con_id from cdb_pdbs where pdb_name = 'MYPDB') and granted_role = 'PDB_DBA'; GRANTEE -------------------- BALAZS SYS