| Password expiry check upon login [message #112504] |
Sat, 26 March 2005 04:25 |
limjh
Messages: 1
Registered: March 2005
|
Junior Member |
|
|
Hi,
I'm new to Oracle Developer and I'm trying to modify an application login program. This program uses the built-in logon procedure in Forms 4.5, under ON-LOGON trigger, and it is working perfectly.
declare
un VARCHAR2(80);
pw VARCHAR2(80);
cn VARCHAR2(80);
begin
if n is not null then
logon(un,pw||'@'||cn);
else
logon(un,pw);
end if;
end;
Now I am required to add a routine, after successful logon to check whether the password has expired and call out the password change program, if the password has not been changed for more than 90 days.
1. Are there any table changes to do, to enable the expiry date checking ?
As an application support I do not have the system login (our office audit policy) and I cannot access the system table where the password is stored and may need to convey instructions to the dba to do changes, if any.
2. Where can I insert the password change program ?
I tried inserting the codes after logon(un,pw||'@'||cn);
but the codes after logon are ignored and I cannot trap the password for checking. It will display error msg 'ORA-01017 : invalid username/password : logon denied' if login failed and continue to applicaton main menu, if login is successful.
Hope to get your advice real soon.
Thank you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
