Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need trigger to change user password...

Re: Need trigger to change user password...

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/03/12
Message-ID: <3507AEC7.209E686F@ubs.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US