Re: Q. Granting Priveleges in Oracle
From: Salahuddin Faruqui <BTJV84A_at_prodigy.com>
Date: 1996/07/12
Message-ID: <4s69b2$l8u_at_useneta1.news.prodigy.com>#1/1
Date: 1996/07/12
Message-ID: <4s69b2$l8u_at_useneta1.news.prodigy.com>#1/1
jagan <jagan_kodali_at_non-hp-paloalto-om2.om.hp.com> wrote:
>
>Hello,
>
>I'd like to know if there is any way to grant priveleges in Oracle to
>alter a row in a table only if that row has been inserted by that user.
>
>A way I can think of is inserting an attribute in the customer table
>showing who the agent is and let the application take care of this
>access.
>
Hi Jagan
Table Partitioning?? Better still, try to inculde the agent attribute and
create a view on it " ....where agent = :user" which would only make
that part of the underlying table accessable for DML.
I hope this helps.
-
Obaid A. Faruqi
Freelance in Portland
Received on Fri Jul 12 1996 - 00:00:00 CEST