Can one bypass the Oracle login screen?

Q

Can one bypass the Oracle login screen?

✍: Guest

A

The first thing that the user sees when using runform is the Oracle logon prompt asking them for their username, password, and database to connect to. You can bypass this screen or customise it by displaying your own logon screen. Eg:
-- ON-LOGON Trigger
declare
uname varchar2(10);
pass varchar2(10);
begin
uname := 'username';
pass := 'password';
logon(uname, pass || '@connect_database');
end;

Alternatively, edit the formsweb.cfg file located in ORACLE_HOME/forms/server creating a config like this:
[my_cfg]
userid=username/password@connect_database
form=MY_FORM.fmx

and after that, access the application like this:
http://<>/forms/frmservlet?config=my_cfg

2011-03-22, 5611👍, 0💬