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,
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-lReceived on Mon Jan 12 2009 - 17:07:40 CST