Re: account unlock/password reset
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: JEREMY.SHEEHAN@xxxxxxx
- Date: Mon, 12 Jan 2009 16:43:41 -0600
Can you compile it under another schema that has alter user (rather ran run
with invoker rights) and grant execute on the procedure to the users needed?
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Mon, Jan 12, 2009 at 3:33 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx>wrote:
> I've co-authored a procedure that does and account unlock and password
> reset. It works great (if you're interested I'll post it, too).
>
>
>
> Now I'd like to give this to level 2 support and have this taken out of the
> hands of the DBA's. We've got a few support users that are ready to use it,
> but I'm not thrilled with granting 'ALTER USER' to them.
>
>
>
> Is there anyway around allowing users to unlock accounts and change
> password without granting 'ALTER USER'?
>
>
>
> Thanks!
>
>
>
> Jeremy
>
> P *Consider the environment. Please don't print this e-mail unless you
> really need to.*
>
Other related posts:
