Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: granting updates to rows
Hi Rene,
Oracle has a thing called 'Fine Grained Access Control'. This was actually build for Oracle web applications. It works with an authenticate procedure that is called for every DDL operation a user wants to do. You can find a lot of information on the subject at Technet: http://technet.oracle.com/docs/products/oracle8i/doc_index.htm . There's an entry here under 'Fine Grained Acces control' which points to all kinds of Oracle documentation on the subject. I think you'll find it very useful...
HTH,
Bastiaan Schaap
Oracle web development,
Desyde BV - Baarn
http://www.desyde.nl/
tel. +31355411711
Rene Nyffenegger <renenyffenegger_at_my-deja.com> wrote in message
news:8n0990$1nm$1_at_nnrp1.deja.com...
> Hi
>
> I was wondering if there is a trick (or even
> a command) that allows me to grant update rights
> for rows with a specific criteriom to selected users
> or roles.
>
> The details:
> We have a table with data for and from multiple customers. These
> customers should be able to see (select) the data of
> all other customers but only write (update) data that
> sort of belong to them. This is, a customer would
> be the owner of a row when he has inserted one and then
> may change this row's data but not an other customer's row's
> data.
>
>
> TIA
>
> Rene
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Aug 13 2000 - 00:00:00 CDT