Re: account unlock/password reset

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Mon, 12 Jan 2009 18:07:40 -0500
Message-ID: <49d668000901121507m51f858a8se9da4a4c2cb79980_at_mail.gmail.com>



Jaremy,

the owner of the procedure needs to have an alter user privilege

the grantee does not

this is what definer rights are about

On Mon, Jan 12, 2009 at 4:33 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com> wrote:

> Is there anyway around allowing users to unlock accounts and change password
> without granting 'ALTER USER'?

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 12 2009 - 17:07:40 CST

Original text of this message