Re: Privs. for updating base tables in a view

In article <4tj3di$idi_at_wizard.pn.com> Tom Alborough <toma_at_micrologic.com> writes:
>From: Tom Alborough <toma_at_micrologic.com>
>Subject: Privs. for updating base tables in a view
>Date: 29 Jul 1996 19:28:50 GMT
 

>To update a view the docs say I need UPDATE privilege on the base
>table(s) or UPDATE ANY TABLE system privilege. I granted UPDATE
>on the base tables with Object Manager but the update failed
>("...not legal...").
 

>How else can I grant UPDATE on the base table or...
>how can I grant (myself) UPDATE ANY TABLE privilege (the privilege
>is not listed in the User Manager screen).
 

>Thanks,
>Tom

Here is a typical situation at our site:

User A is owner of base_table
User B is owner of table_view on base_table User C update table_view

What you need is

1. grant update on base_table to B with grant option
2. create table_view and grant update on table_view to C

Michel Lalonde. Received on Tue Jul 30 1996 - 00:00:00 CEST