Autentification interface [message #580152] |
Wed, 20 March 2013 17:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/379e55f070b5a4b7b6f328897bd559f9?s=64&d=mm&r=g) |
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 #580155 is a reply to message #580154] |
Wed, 20 March 2013 18:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13963 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 #580220 is a reply to message #580217] |
Thu, 21 March 2013 08:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
goldray wrote on Thu, 21 March 2013 13:39how ?
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?
|
|
|
|
|
|
|
|
|