Re: Forms: covert login for update

From: Michael Nolan <nolan_at_helios.unl.edu>
Date: 8 Jan 1994 01:35:52 GMT
Message-ID: <2gl2lo$8uc_at_crcnis1.unl.edu>


wvan_at_moose.uvm.edu (Warren Van-Wyck) writes:

> Is it feasible to modify SQL*Forms so that it accepts a 'read'
> id/password and then does another covert login using an 'update'
> id/password? If so, would someone share the code?
 

> Or is there some other way?

With Oracle 7 you should be able to do this with roles. Define an 'update' role with an authorization password. This needs to be a non-default role. There is a package procedure that you can call to enable roles.

I've done this with roles but without the password feature, I think I found the instructions for this in the online documentation with 7.0.12. (On an NCR 3445.)

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)
Received on Sat Jan 08 1994 - 02:35:52 CET

Original text of this message