Privs. for updating base tables in a view

From: Tom Alborough <toma_at_micrologic.com>
Date: 1996/07/29
Message-ID: <4tj3di$idi_at_wizard.pn.com>#1/1

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 Received on Mon Jul 29 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Simon Lee: "OCI question"
Previous message: Badri Narasimhan: "ODBC - ORACLE 7.2 Connection problem on NT 3.51"
Next in thread: Ayokunle Giwa: "Re: Privs. for updating base tables in a view"
Reply: Michel Lalonde: "Re: Privs. for updating base tables in a view"
Reply: Ayokunle Giwa: "Re: Privs. for updating base tables in a view"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message