Updates Through Views DBv9.2.0.2

From: Lisa R. Clary <lisa_at_cog.ufl.edu>
Date: Wed, 25 Jun 2003 10:11:38 -0700
Message-ID: <F001.005B95CD.20030625090954@fatcity.com>

I am trying to use a 3rd party tool via odbc (or other means) to perform updates to a single oracle table through a view using a gui front end. I have been successful at doing the updates through a view using sql worksheet or sql editor in toad, but can't get it to update using ms access or the schema browser in toad (really would prefer using access linked tables), it just 'dings' basically indicating it can't do it. If I pull in the underlying table (as a linked table), I can update that just fine through ms access, but it allows for all other fields to be updated by the user and not just a select few.

The ultimate goal is to create a view with subsets of the underlying table to which only 2 of the 5 columns of the view can be updated. Even though I have granted perms on the view itself including grant update (modifier, date_rec) on test_table to dms, no luck, I still am missing something. Any ideas?

thanks,

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Lisa R. Clary
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 25 2003 - 12:11:38 CDT