title: Retrieving Oracle Password_Verify_Function
body: <p>I am an IS auditor and I would like to check how we can retrieve the <code>PASSWORD_VERIFY_FUNCTION</code> assigned to users. I understand the script <code>utlpwdmg.sql</code> can be executed to setup the default password resource limits.</p>
  
  <p>If changes were made using <code>ALTER PROFILE</code>, the script <code>utlpwdmg.sql</code> will not show the latest settings. </p>
  
  <p>Please let me know what SQL commands I can execute to show <em>what is the <code>PASSWORD_VERIFY_FUNCTION</code> stored and used in the system</em>.</p>