APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reset user password, ORA-20001 error

428025May 28 2008 — edited May 29 2008

Hi all,

I want to include a facility on an application for users to reset their password if they forget it. I've found the apex_util.reset_pwd function which looks perfect.

However in order to run it I have to be logged in as an admin user. This doesn't seem to work here, as by definition the user won't be logged in at all because they've forgotten their password! Trying it returns this error :

ORA-20001: User requires ADMIN privilege to perform this operation

which makes sense as I'm not logged in.

I've had a look over this forum can't seem to track down an answer so any help is appreciated.

Thanks,

Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2008

Added on May 28 2008

#apex-discussions

5 comments

1,111 views