Re: GRANTs (SQL*Plus & SQL*Forms)

Mike Oswald (moswald_at_cwis.unomaha.edu) wrote:
> I have issued grants to allow some customers to UPDATE several columns in a
> table. The UPDATEs are handled via SQL*Plus. When I try to apply the same
> logic to fields displayed in a FoRM the UPDATEs fails. Is this because the
> customer has SELECT on all fields and only UPDATE on several of these fields
> and when SQL*Forms tries to update the columns/fields it is actually trying to
> update the whole record?

Yes, exactly that.
> Has anyone tried this? What am I missing?

If you're using Forms 3, you could try using an ON-UPDATE trigger, consisting of an update statement for just the columns you want. Eg.
  UPDATE MY_TABLE

  SET COL_1 = :block.col1,
      COL_3 = :block.col3
  WHERE ID  = :block.id

or something like that -- I haven't tried it myself ... :-)

--
  _________________________   ______________________________________
 /  Tommy Wareing          \ /  Whadda you mean it's all my fault?  \
|  p0070621_at_brookes.ac.uk   X   Deny everything, and if you can't:   |
 \  0865-483389            / \             Pass the Buck            /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~