Re: Alter User in Stored Procedure

From: <brijeshmathew_at_gmail.com>
Date: 15 Aug 2005 09:59:41 -0700
Message-ID: <1124125181.076679.325060@o13g2000cwo.googlegroups.com>

John Rose wrote:
> 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

Hi John

I assume that you are doing this using EXECUTE IMMEDIATE. GRANT ALTER USER privilege to the User that owns your stored procedure, it should work fine.

Regards

Brijesh Mathew Received on Mon Aug 15 2005 - 11:59:41 CDT