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:
- 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;
- Set the
db.cdb.adminUser
anddb.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.