Authentication for Pluggable Database Lifecycle Management

You cannot have an ORDS enabled schema in a container database. To perform the PDB lifecycle management operations, the default CDB administrator credentials, db.cdb.adminUser and db.cdb.adminUser.password must be defined in the connection pool. In this case, it is not required to specify an user schema in the URI.

To define the default CDB administrator credentials, perform the following steps:

1. Create the CDB administrator user and grant the SYSDBA privilege. In this example, the user is called C##DBAPI_CDB_ADMIN. However, any suitable common user name can be used.

   
   CREATE USER C##DBAPI_CDB_ADMIN IDENTIFIED BY <PASSWORD>;
   GRANT SYSDBA TO C##DBAPI_CDB_ADMIN CONTAINER = ALL;

2. Set the db.cdb.adminUser and db.cdb.adminUser.password properties for the connection pool as shown in the following code snippet:

   echo db.cdb.adminUser=C##DBAPI_CDB_ADMIN as SYSDBA > cdbAdmin.properties

   echo db.cdb.adminUser.password=<PASSWORD> >> cdbAdmin.properties

   java -jar ords.war set-properties --conf apex_pu cdbAdmin.properties

   rm cdbAdmin.properties

The ORDS role, SQL Administrator must be used to access the https://<server>/ords/_/db-api/stable/database/pdbs/ services.