OraFAQ Forum: Forms » User Define Login Form

Home » Developer & Programmer » Forms » User Define Login Form (oracle, forms 6i, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User Define Login Form [message #505443]

Tue, 03 May 2011 02:50

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Dear All

I have designed a Login form which takes username, password and connect string is hardcoded.

I have compiled it, made an fmx file. created a shortcut to desktop. given the BIN path in shortcut.

when i want to lauch it, oracle's default login popup is shown.
It can be by passed while defining username/password@string in shortcut properties but it reveals the password. every one can access it.

I want to launch my own form without logging in to oracle. what to do? how can i avoid default login popup?

.fmb is attached.

any solution is welcome.
Regards.

Attachment: MyLogOn.fmb
(Size: 52.00KB, Downloaded 1553 times)

Report message to a moderator

Re: User Define Login Form [message #505513 is a reply to message #505443]

Tue, 03 May 2011 07:42

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Use ON-LOGON Trigger with below code at Form Level.

 
LOGON('A','PSSWORD||'@'||'STRING');

Hope It'll help you.

Regards,
Irfan

Report message to a moderator

Re: User Define Login Form [message #505565 is a reply to message #505513]

Tue, 03 May 2011 23:21

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

thanks a lot.
it really worked the way i wanted.

regards.

Report message to a moderator

Re: User Define Login Form [message #505572 is a reply to message #505565]

Wed, 04 May 2011 01:03

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Thank you for your feedback.

Report message to a moderator

Re: User Define Login Form [message #505628 is a reply to message #505513]

Wed, 04 May 2011 05:57

oralover2006
Messages: 144
Registered: January 2010
Location: India

Senior Member

ranamirfan wrote on Tue, 03 May 2011 18:12

Dear,

Use ON-LOGON Trigger with below code at Form Level.
 
LOGON('A','PSSWORD||'@'||'STRING');
Hope It'll help you.

Regards,
Irfan

this password also can be revealed from .fmx ( even if no .fmb file is there ) file using a smart editor like UltraEdit etc. as it contain plain text password Smile

[Updated on: Wed, 04 May 2011 05:58]

Report message to a moderator

Re: User Define Login Form [message #507590 is a reply to message #505513]

Tue, 17 May 2011 04:44

qaiserjavid
Messages: 25
Registered: May 2011
Location: Pakistan

Junior Member

respected friend;
which one i click fmb file or fmx. Because when i insert this code and click the fmb file it shows error.
LOGON('A','PSSWORD||'@'||'STRING');

please help me.

Attachment: Error.txt
(Size: 0.22KB, Downloaded 1179 times)

Report message to a moderator

Re: User Define Login Form [message #507596 is a reply to message #507590]

Tue, 17 May 2011 04:56

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When you compile a source form (which is an .FMB), you get an executable .FMX file. In order to run a form, you might need Forms runtime components installed (in 6i) or you'll run them on the web (9i and above) so you need (at least) OC4J running on your own computer along with the web browser.

Report message to a moderator

Re: User Define Login Form [message #508035 is a reply to message #507590]

Thu, 19 May 2011 02:26

oralover2006
Messages: 144
Registered: January 2010
Location: India

Senior Member

qaiserjavid wrote on Tue, 17 May 2011 15:14

respected friend;
which one i click fmb file or fmx. Because when i insert this code and click the fmb file it shows error.
LOGON('A','PSSWORD||'@'||'STRING');

please help me.

count your Single Quotes in this LOGON statement...

Report message to a moderator

Re: User Define Login Form [message #508043 is a reply to message #508035]

Thu, 19 May 2011 03:07

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

LOGON('A','PSSWORD'||'@'||'STRING');

copy & paste this.

Report message to a moderator

Previous Topic:	FORM SYNCHRONIZATION
Next Topic:	Display multiple forms at runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 15:33:56 CDT 2024