979155 wrote:What do you mean by logout ? exit from the application or re open the login screen.. ?
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:
select user_name into v1,pass into v2 from authetification where pass=:auth.pass
if v1 != NULL and v2 != NULL then
message('pass or user is false');
How I can to manage the "logout" for the user ?
Hope this helps
979155 wrote:Simple is...
is that preferably create users using create user ... or create a table like I did?
change these properties of txt_password
if :authentication.txt_password is null then select round(dbms_random.value(222222,999999)) into :authentication.txt_password from dual; end if;
in this case I can use "pass_words" as a primary key?If the resulting index can be created (http://ora-01404.ora-code.com/) you could, but why would you do that? The key is the username, not the password. Also it seems that you are storing the passwords in plain text in your table which in itself is a very bad idea.
in this case I can use "pass_words" as a primary key?