I am using Oracle security for my application and would like to allow users
to change their own passwords without using SQLPlus. I am attempting to use
"ALTER USER username IDENTIFIED BY newpassword REPLACE oldpassword" in a
stored procedure to provide this functionality, but it always gets an
insufficent priveleges error. The users can change passwords freely at the
SQLPlus prompt, but cannot do the same via the procedure.
Does anyone have any ideas?
--
John Rose
Maxim Consulting
(405) 923-2400
www.maximconsulting.net
Powered by the OKC Broadband Network
Received on Mon Aug 15 2005 - 11:06:49 CDT
