0

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?

1

CREATE PLUGGABLE DATABASE

ADMIN USER

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.