Home » Developer & Programmer » Forms » security issue/shortcut to mmx :
security issue/shortcut to mmx : [message #84447] Tue, 16 March 2004 18:48 Go to next message
bluebyte
Messages: 25
Registered: September 2003
Junior Member
hi!

since we can't make an exe with forms/menus...we need to make shortcut on the desktop of client machines to invoke the mmx.

but, this shortcut requires the connection parameters  (username/password@database) as arguments.

so, the connection parameters are exposed at client side.

would anyone pls suggest the method to hide these parameters?

waiting for ur reply...

thnx in advance,

gangadhar

 

 

 
Re: security issue/shortcut to mmx : [message #84458 is a reply to message #84447] Wed, 17 March 2004 01:41 Go to previous messageGo to next message
Jeslie Simpson
Messages: 10
Registered: January 2003
Junior Member
Hi Gangadhar (OmegaCube ?)

I think it is not possible to hide the logon info.

but what you can do is give a dummy userid/passwd in the shortcut and in the Pre-Logon Trigger of your Main form use the LOGON buildin to connect to the actual userid.

Hope this might help you

Thanks
Re: security issue/shortcut to mmx : Hurray! [message #84466 is a reply to message #84458] Wed, 17 March 2004 19:44 Go to previous message
bluebyte
Messages: 25
Registered: September 2003
Junior Member
hi jeslie!
thnx for ur suggestion..
i tried this in the shortcut.

C:ORANTBINF50RUN32.EXE conn.fmx foo/foo@foo

but, LOGON built-in is not a valid procedure in pre-logon trigger.so, i put the foll. code in ON-LOGON trigger..

/*
* ON-LOGON trigger
*/
declare
un varchar2(80);
pw varchar2(80);
cn varchar2(80);

begin

un := 'actual_un' ;
pw := 'actual_pw';
cn := 'actual_cn';
LOGON(un,pw||'@'||cn);

end;
/*
* end of trigger
*/

thnx a lot for the help.

hav fun,
Ganga (bluebyte)
Previous Topic: Form for 9iDS not "running" - webpage doesnt load
Next Topic: *Connecting to Oracle from Dev Form? How to? *
Goto Forum:
  


Current Time: Fri Jul 05 12:19:48 CDT 2024