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 theRequire Change of Password on First Use
box, and then clickApply 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;