Q. Granting Priveleges in Oracle
From: jagan <jagan_kodali_at_non-hp-paloalto-om2.om.hp.com>
Date: 1996/07/11
Message-ID: <31E547FE.2114_at_non-hp-paloalto-om2.om.hp.com>#1/1
Date: 1996/07/11
Message-ID: <31E547FE.2114_at_non-hp-paloalto-om2.om.hp.com>#1/1
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.
For example: If an agent "A" handles customer "C", Customer "C" record
should only be altered by agent "A"
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.
Any ideas if there is a better way or if there is a GRANT privelege in Oracle that can accomplish this task.
Thanks, in advance.
Jagan Kodali
(408)985-2750
Received on Thu Jul 11 1996 - 00:00:00 CEST