Re: help changing passwords forms 4.5

From: <Jim_Ritchie_at_eastdunbarton.ccmail.compuserve.com>
Date: 1996/04/30
Message-ID: <960430154617_702420.204300_BHD48-8_at_CompuServe.COM>#1/1

     Use the FORMS_DDL built-in. This built-in can issue DDL statements 
     from forms 4.5 triggers. In your trigger you could code something like

     declare
     string1 varchar2(100);
     begin
     user_name := upper(get_application_property(USERNAME)); string1 := 
     'alter user '||user_name||' identified by  '||:password.new_password;
     forms_ddl(string1);
     end;

     You would probably want to check also that the built-in has executed 
     successfully - check the Forms 4.5 Referenec Manual Volume 1 for more 
     details on this built-in.

     Hope this helps.

     Jim Ritchie
     East Dunbartonshire Council
     Scotland  


______________________________ Reply Separator _________________________________

Subject: help changing passwords forms 4.5 Author: dba_at_sdc.com at Internet
Date: 28/04/96 11:15 AM

From: dba_at_sdc.com
Newsgroups: comp.databases.oracle
Organization: Erols Internet Services Message-ID: <3183B5D9.4BC0_at_sdc.com>

Hello,

Our forms 4.5 application must allow a user to change his password. PL/SQL won't recognize the grant or alter commands. Does anyone have ideas as to how we can get around this?

Thanks

---

East Dunbartonshire Council.

          E-mail problems to postmaster_at_eastdunbarton.ccmail.compuserve.com

---

Received on Tue Apr 30 1996 - 00:00:00 CEST