Databases Reference
In-Depth Information
Command line
When we still have access, we can use the web interface of APEX. If not we can use
the command line:
1.
Start SQL*Plus and connect as
SYS
with the
SYSDBA
role.
2.
Unlock the
APEX_xxxxxx
account by issuing the following command:
alter user APEX_xxxxxx account unlock;
3.
Connect to the
APEX_xxxxxx
account. If you don't remember your password,
you can just reset it, without impacting the APEX instance.
4.
Execute the following (use your own username, e-mail, and password):
BEGIN
wwv_flow_api.set_security_group_id
(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'second_admin',
p_email_address => 'email@company.com',
p_web_password => 'second_admin_password') ;
END;
/
COMMIT
/
5.
The new administrator is created. Connect again as
SYS
with the
SYSDBA
role
and lock the account again with the following command:
alter user APEX_xxxxxx account lock;
6.
Now you can log in to the
Internal
workspace with your newly created
account and you'll be asked to change your password.
