Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

When does utlpwdmg.sql run?

ponderdjApr 19 2014 — edited Apr 22 2014

Questions:

1. When does utlpwdmg.sql run? (Other than when a DBA manually runs it)

     - When a user changes his own PWD?

     - What about when a DBA changes a users's PWD?

     - When a user with a profile assigned a password verify function signs in?

     - Other times?

2. Can you put multiple password verify functions within utlpwdmg.sql and apply different functions to different profiles? If so, does only that function run when a user tries to change their PWD?

3. What about alter statements placed at the bottom of utlpwdmg.sql to modify the password enforcement parameters in dba_profiles. When do those run?

If there's a manual that describes all of this well, I'll happily read it. I just can't find this information anywhere.

Thanks,

David
This post has been answered by EdStevens on Apr 22 2014
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 20 2014
Added on Apr 19 2014
#general-database-discussions, #password
11 comments
9,180 views