Posted by: prankster April 7, 2011
sql help
Login in to Rate this Post:     0       ?        
by source do you mean the source code of the function, the one that is in  $ORACLE_HOME/rdbms/admin/utlpwdmg.sql?
Anyway here is a sql that displays profile, resource_naem and Limit
SELECT profile, resource_name, limit
FROM dba_profiles
WHERE resource_name='PASSWORD_VERIFY_FUNCTION';


Did some more search..it looks like when u run utlpwdmg.sql, it does three things
-creates a function called verify_function_11g  (for 11 g)
-Alters profile which enables the default profile with the new password fucntion.
-Creates legacy function verify_function.

if you are trying to print the source of these two functions, then first run that sql, that will create these two function.
Then do
select TEXT from all_source where TYPE='FUNCTION'
check if your function is there
and then do
select TEXT from all_source where name='VERIFY_FUNCTION'

I've not tried this myself, dont have admin rights.
See if this helps, or someone else might have better answer.
Last edited: 07-Apr-11 05:50 PM
Read Full Discussion Thread for this article