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;