To prevent the workspace admin account’s password from being changed, do the following steps:
Click Manage Workspaces on the Admin Dashboard.
Click Manage Developers and Users.
Click the Edit button (pencil) beside the ADMIN user in the BIR_SPMAT workspace.
Select No in the Require Change of Password on First Use box, and then click Apply Changes.
A confirmation message appears.
You’re done. You can create more users if you need to, but this is optional.
Click Sign out.
Start SQLPLUS and connect as SYS user.
Perform the following commands to add grants to BIR_SPMAT:
alter user bir_spmat grant connect through APEX_REST_PUBLIC_USER;
alter user bir_spmat grant connect through APEX_PUBLIC_USER;
alter user bir_spmat grant connect through ORDS_PUBLIC_USER;
alter user bir_spmat grant connect through APEX_LISTENER;