Re: Forms: covert login for update

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)