GRANTs (SQL*Plus & SQL*Forms)
From: Mike Oswald <moswald_at_cwis.unomaha.edu>
Date: Wed, 11 Aug 1993 15:18:53 GMT
Message-ID: <1993Aug11.151853.12269_at_news.unomaha.edu>
Date: Wed, 11 Aug 1993 15:18:53 GMT
Message-ID: <1993Aug11.151853.12269_at_news.unomaha.edu>
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?
Mike Oswald _ o Univ. Of NE Medical Center ___\o_ __o <|\ Computing Services/Telecomm ~~~~~~ _ \<_ _\ 600 S. 42nd ST. (_)/(_) /Omaha NE 69198-5030 Received on Wed Aug 11 1993 - 17:18:53 CEST