APEX 4.2 and workspace info
APEX system variables
Host address, user IP, SID and OWA_UTIL package
Few days ago we had a bizarre case at my client site that no one knew the workspace admin password and people were asking about what type of configuration and details we can get about the APEX instance currently in use. Sounds familiar?
So what can we do when we don't have access to workspace Admin passwords. Here are few useful functions that known to help in different situations.
SELECT SYS_CONTEXT ('USERENV', 'IP_ADDRESS') FROM DUAL;
select sys_context('USERENV', 'OS_USER') from dual;
SELECT sys_context('USERENV', 'DB_NAME') FROM DUAL;
select SYS_CONTEXT('USERENV', 'HOST', 25) from dual;
On the other side if you have admin to any of workspace instances you can use always helpful OWA_UTIL package.
For more details check http://docs.oracle.com/cd/E12839_01/portal.1111/e12042/psutil.htm
All possible details about your APEX environment can be retrieved by running:
Of course to get around all of this you can reset your passwords. If you are wondering how check my next post.
Hope this helps.