I belive a login trigger is a global database tigger and I don't get the nesseccary permission to create one. I don't think that you can restrict the login trigger to a special schema.
The advice from Michael will also not work for security reasons. I don't think you can create a user with alter user permission and restrict them to a special group of users or a schema. This users can only grant this permission to me, but if they are able for this they must login and the problem doesn't come up.
Can you use oracle forms? They support changing password at first login. My idea is, if this case comes up, leading the user to another page with a small forms application as applet, pugged in this page, let them change the password and lead back to the main application. Perhaps the handle can be handed over to the application by JavaScript? But I think this is not a good style.
I've also tried the interactive dbi shell. I want to build it in in backticks and try to handle the problem, but the shell gots the same problem.
I cannot belive that this case is not dealt in the driver? Finally I was stepping through the source but haven't found a solution yet.
Thanks Volker
Gold, Samuel (Contractor) wrote:
Don't set the password to expire, set the password to expire in 1 day or so. That way they can login then make them change their password. I have the same issue and have not yet figured out all of the details. If you come up with something let me know. You may be able to use a database login trigger, but I think those are new to oracle 9i. If I figure out something good I will be sure to give you an update.
Thanks, Sam Gold
-----Original Message----- From: Volker Schweitzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:05 PM To: [EMAIL PROTECTED] Subject: Changing passward at login
Hi,
I've to write an internet db appication with Oracle. The problem is that new created db users
have to change their password at the first login (password expired). How can I handle this?
The connect fails with the message; "...password expired...." and gives no dbi handle back and
without a handle I cannot change the password.
Any ideas??
Thanks Volker
