When does utlpwdmg.sql run?

[ponderdj]

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

 

[ponderdj]

In case anyone is interested in the solution:

https://community.oracle.com/thread/3549566