Re: Privilege on record/value

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 16 Jun 1999 16:44:22 GMT
Message-ID: <3767D5C8.B9C1D76C@sympatico.ca>

Marc,

May i suggest you build a view on your table and grant privileges to this view to your user.

The view could have "where project='XXXX'".

If a view is based on one table only and constains all the mandatory fields, you can read, insert, update and delete from this view. On Oracle 8, many of these restrictions have been removed.

Regards,

Marc Mazerolle
InforMaze Technologies

D'un Marc a un autre....

Marc Ottone wrote:

> Hi,
>
> I'd like to define users privileges relating to record value stored in
> tables (ie user AAA would only be able to update/delete records with column
> PROJECT = 'XXX').
> Can anyone help me?
> TIA
>
> Marc
> Conservatoire et Jardin Botaniques
> Geneva - Switzerland
> ottone_at_cjb.unige.ch
Received on Wed Jun 16 1999 - 11:44:22 CDT