Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Force password change after first logon

853896Apr 8 2011 — edited Apr 11 2011
Dear all,

I'm sorry if this topic was discussed already, i did a search in this forum and in the web but i got inconsistent proposals.

Background: We have two applications using the same database. One is the main application and the other is used to administrate it (e.g. user administration).

What we want to accomplish is while creating a user there should be an option to force a password change for the newly created user on his first login.
So basically what I'm looking for is a statement like this: "alter user newuser password expire grace;"

While it is possible to set a password expired there seems to be no way to set a password to expired grace with one statement.

My next approach would be to create a temporary user profile with a password life time of 0 and a grace period. Assign this profile to a new user and after changing his password assign our standard user profile to him.
But before starting the implementation i wanted to check here if this is the way to go or if there is a more elegant way to accomplish this, since I'm no expert in this field.

Thanks in advance for any proposals

Edited by: 850893 on Apr 8, 2011 3:16 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2011
Added on Apr 8 2011
8 comments
15,276 views