Posted by: prankster April 7, 2011
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.
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