Re: Need trigger to change user password...

From: Ian Jones <ijones_at_slip.net>
Date: 1998/03/12
Message-ID: <35075d02.5637530@news.slip.net>#1/1

If it is an Oracle form you can use FORMS_DDL if you really want to have the code in the database then you need to write a small dynamic SQL procedure using DBMS_SQL.

(Look at DBMS_SQL, since a GRANT or an ALTER USER is a DDL statement it is straightforward to write).

Don't you want ALTER USER rather than a GRANT?

Ian

On 11 Mar 1998 22:01:18 GMT, "TL" <lamkin_at_tiac.net> 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
Received on Thu Mar 12 1998 - 00:00:00 CST