Databases Reference
In-Depth Information
Creating a second administrator
When installing APEX, by default the workspace
Internal
with the administrator
user
Admin
is created. Some users know more than the average end user. Also,
developers have more knowledge than the average user. Imagine that such users try
to log in to either the APEX Administration Services or the normal login page with
the workspace
Internal
and administrator
Admin
, and consequently use the wrong
password. As a consequence, the Admin account would be locked after a number of
login attempts. This is a very annoying situation, especially when it happens often.
Big companies and APEX Hosting companies with many workspaces and a lot of
anonymous users or developers may suffer from this. Fortunately there is an easy
solution, creating a second administrator account.
Login attempt in workspace Internal as Admin
If the account is already locked, we have to unlock it irst. This can be easily done by
running the
apxchpwd.sql
script, which can be found in the main Apex directory of
the unzipped installation ile of APEX:
1.
Start SQL*Plus and connect as
sys
with the
sysdba
role.
2.
Run the script by entering
@apxchpwd.sql
.
3.
Follow the instructions and enter a new password.
Now we are ready to create a second administrator account. This can be done in two
ways, using the web interface or the command line.
