Home » Developer & Programmer » Forms » Autentification interface (oracle forms 10g ,win xp pack 2)
Autentification interface [message #580152] Wed, 20 March 2013 17:25 Go to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
Hi,
I want to create authentification interface contains two items and 1button.
I started by creating table "Autentification" which contains 2 columns.
when-button pressed trigger:
declare
v1,v2 varchar2(10);
begin
select user_name into v1,pass into v2 from authetification where pass=:auth.pass

if v1 != NULL and v2 != NULL then 
call_form('...');
else
message('pass or user is false');
end if;
end;


How I can to manage the "logout" for the user ?

I need your opinion for my code and all ...
Re: Autentification interface [message #580153 is a reply to message #580152] Wed, 20 March 2013 18:20 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
1) The code won't compile.
2) Why not use oracle accounts?
3) I bet you're storing the password unencrypted.
4) What do you want it to do on logout?

Re: Autentification interface [message #580154 is a reply to message #580153] Wed, 20 March 2013 18:32 Go to previous messageGo to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
1)why?
2)by creating user? : create user ... ?
3)the password be masked
4)when the user wants to disconnect

=> I want to give a password for each user, how can I do that?
Re: Autentification interface [message #580155 is a reply to message #580154] Wed, 20 March 2013 18:45 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
1) Since when can you have the into keyword twice in 1 select? Your declare section is wrong and you can't check null that way (last one isn't a compile error but it's still wrong). Plus the check for null is pointless even if you were doing it right, only way those variables are null is if the select found no rows, in which case you'll get a no_data_found error. Also if two users have the same password you'll get a too_many_rows error.
2) Yes.
3) how?
4) That doesn't answer my question at all. What do you want to happen when the user wants to disconnect? What do you expect to happen beyond them closing the form?

goldray wrote on Wed, 20 March 2013 23:32

=> I want to give a password for each user, how can I do that?

What's preventing you from creating passwords?
Re: Autentification interface [message #580156 is a reply to message #580155] Wed, 20 March 2013 19:48 Go to previous messageGo to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
1)declare
nb number;
begin
select count(*)into nb from authetification where pass=:auth.pass and user_name=:auth.user_name;

if nb<>0 then
...
its ok ?
2)OK ,so I will use the table all_users for the test ?
3)put yes to the property data masked
4)exit from the application ,and return to the authentication interface
5)I want the system manages the creation of passwords
Re: Autentification interface [message #580176 is a reply to message #580156] Thu, 21 March 2013 02:46 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my opinion, you are reinventing the wheel. The only difference - once you're done with it - is that your wheel will be quadratic.

What's wrong with Cookiemonster

2) Why not use oracle accounts?
Re: Autentification interface [message #580197 is a reply to message #580176] Thu, 21 March 2013 03:56 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
Indeed, why not oracle logins?
If you use them you don't need to write any code. Forms default login functionality will handle it.
Re: Autentification interface [message #580217 is a reply to message #580176] Thu, 21 March 2013 08:39 Go to previous messageGo to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
how ?
I want to do an authentication interface for my application to make secure
Re: Autentification interface [message #580218 is a reply to message #580217] Thu, 21 March 2013 08:41 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, start coding.
Re: Autentification interface [message #580219 is a reply to message #580218] Thu, 21 March 2013 08:43 Go to previous messageGo to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
I'll start, just I want to know how to use oracle logins for my application
Re: Autentification interface [message #580220 is a reply to message #580217] Thu, 21 March 2013 08:44 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
goldray wrote on Thu, 21 March 2013 13:39
how ?
I want to do an authentication interface for my application to make secure


And that stops you from using oracle forms default login functionality how?
Re: Autentification interface [message #580221 is a reply to message #580220] Thu, 21 March 2013 08:49 Go to previous messageGo to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
you're right, but my application must be deploy on the web ,So I need to create an authentication interface
Re: Autentification interface [message #580224 is a reply to message #580221] Thu, 21 March 2013 09:05 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you really think oracle hasn't designed their own authentication to work on the web?
Re: Autentification interface [message #580238 is a reply to message #580224] Thu, 21 March 2013 16:11 Go to previous messageGo to next message
goldray
Messages: 108
Registered: December 2012
Senior Member
I think that oracle manages authentication
Re: Autentification interface [message #580240 is a reply to message #580238] Thu, 21 March 2013 16:35 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So? You haven't provided any evidence why would your "solution" be better than Oracle's built-in capabilities.
Re: Autentification interface [message #580333 is a reply to message #580240] Fri, 22 March 2013 16:25 Go to previous messageGo to next message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
Yes Dear @littlefoot is right there is no "solution" better than Oracle's built-in capabilities.
but you wanted your own authentication it means if you run your main menu first should asked username and password which you will design means login authentication anyway i can design for you as per your requirment you need coding or .FMB file





Mughal
Smile

Re: Autentification interface [message #580532 is a reply to message #580333] Mon, 25 March 2013 12:49 Go to previous message
goldray
Messages: 108
Registered: December 2012
Senior Member
Yes I want authentification interface for my own application
Previous Topic: migration forms&reports 6i to 11g screen issues
Next Topic: How to call a canvas from menu
Goto Forum:
  


Current Time: Mon Jul 01 10:26:44 CDT 2024