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 and db.cdb.adminUser.password properties for the connection pool as shown in the following code snippet:
```
ords config set db.cdb.adminUser "C##DBAPI_CDB_ADMIN as SYSDBA"
ords config secret db.cdb.adminUser.password
```

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