Friday 19 September 2014

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 utl_inaddr.get_host_address(sys_context('userenv','server_host')) from dual;
 
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. 


All possible details about your APEX environment can be retrieved by running:
begin
OWA_UTIL.print_cgi_env;
end;

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.

Regards,
Lino


No comments:

Post a Comment