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>
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?
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