Re: I get an error while creating a new user....

JCR wrote:
>
> Hi, when I try to create a new user from internal in 817, I get the
> below error. Can someone please tell me how I can get around this?
> TIA.
>
> SQL> create user joe_r identified by xxxx
> 2 ;
> create user joe_r identified by xxxx
> *
> ERROR at line 1:
> ORA-07443: function for password verification not found

Looks like someone has asociated a password verification function for the default profile - fix up that and the problem should go away.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."