Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need trigger to change user password...
TL wrote:
>
> I have tried issuing a GRANT statement in both a trigger and in a stored
> procedure, but can't get past the compile phase. I am hoping to change the
> user's Oracle password via PL/SQL to keep that password in synch with a
> password in our application. Possible?
>
> Todd
Hi
possible, but a password is changed via the "alter user xyz identified
by passwd" command
and not via a Grant command.
rgds
eugen
Received on Thu Mar 12 1998 - 00:00:00 CST