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

From: <alacy_at_hayes.com>
Date: 12 Aug 93 13:03:09 EDT
Message-ID: <7772.2c6a3f8d_at_hayes.com>

In article <1993Aug11.151853.12269_at_news.unomaha.edu>, moswald_at_cwis.unomaha.edu  (Mike Oswald) writes:

> 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?
>
> Has anyone tried this? What am I missing?

This is set on the Block Definition screen of SQL*Forms 3.0. There is the option Column sec you must use this if the form contains columns which are set as select only via grants. What I think the runform does is to read the grant tables to get the needed information, to know which columns which can not be updated.

The following is a sample Block Definition showing the help message for the Column Security check box. I have tried this and it works fine.

  Action foRm Block Field Trigger Procedure Image Help Options

-----------------------------   Block Definition  ------------------------------
 +----------------------------------------------------------------------------+
   Block: gl_acct                        | -- Records --  | Array Size:       
   Table: gl_acct                        | Displayed: 1   | [   ] Prim Key    
   Sequence Number: 1                    | Buffered:      | [ X ] In Menu     
                                         | Lines per:     | [   ] Column Sec  
 +----------------------------------------------------------------------------+
   Description: gl_acct                                                       
 +----------------------------------------------------------------------------+
   ------------------------- Default Where/Order By ------------------------- 
                                                                              
                                                                              
                                                                              
                                                                              
 +----------------------------------------------------------------------------+
   --------------------------------- Comment -------------------------------- 
                                                                              
                                                                              
                                                                              
                                                                              
 +----------------------------------------------------------------------------+

Should column security be enforced for this block?

-- 
Allen Lacy, Principal Analyst | internet:  alacy_at_hayes.com              
(404) 840-9200 (x.2131)       | uucp:      uunet!hayes!alacy     
Hayes Microcomputer Products  | U.S.Mail:  p.o.box 105203, Atlanta, GA 30348

Received on Thu Aug 12 1993 - 19:03:09 CEST