Posted by: CyLegend April 8, 2011
sql help
Login in to Rate this Post:     0       ?        
 Hi Prankster,

Do you know of a script that will run through the table "dba_source" as well as "dba_profiles" to get to the user password ("password_verify_function" of dba_profiles").  I want to automate to list out all source code withought having to access each dba table.  The original script that I tried below did not seem to work:  Any help will be appreciated.

select name, text from dba_source where name in (select limit from dba_profiles where resource name = "PASSWORD_VERIFY_FUNCTION");

Thanks again!
Read Full Discussion Thread for this article