Running script utlpwdmg.sql in Oracle 10g

Welcome Guest ( Log In | Register )

Running script utlpwdmg.sql in Oracle 10g, Running script utlpwdmg.sql in Oracle 10g

donsls View Member Profile	May 7 2012, 01:52 PM Post #1
Advanced Member Group: Members Posts: 31 Joined: 16-November 06 Member No.: 5,651	I am trying to enable password complexity in Oracle 10g by using the utlpwdmg.sql file. When I manually run this using SQL plus, I get the following result Function created Alter Profile Default Limit Error at line 1 ORA-07442: function VERIFY_FUNCTION notnfound Could anyone let me know how to correct this please? I had no trouble setting this up in Oracle 9i. Any help is greatly appreciated.

donsls View Member Profile	May 7 2012, 02:05 PM Post #2
Advanced Member Group: Members Posts: 31 Joined: 16-November 06 Member No.: 5,651	Found the solution. I was running the script under a non admin user. Ran it under sys and everythig worked.

burleson View Member Profile	May 7 2012, 03:07 PM Post #3
Advanced Member Group: Members Posts: 10,430 Joined: 26-January 04 Member No.: 13	Glad you found a solution! Thanks for sharing, this may help others . . . . -------------------- Hope this helps. . . Donald K. Burleson Oracle Press author Author of Oracle Tuning: The Definitive Reference

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Time is now: 19th June 2013 - 04:04 AM