Re: Record level permissions only for update

In article <slrnacflon.4tk.A.Christofides_at_acheloos.itia.civil.ntua.gr>, A.Christofides_at_hydro.ntua.gr says...
>
>Good morning,
>
>I want different users to have different permissions on different rows
>of the same table. In old newsgroups messages I found that this is
>usually accomplished by adding a column to the table, e.g. with the
>username of the "owner" of the record, and creating a view which
>selects only the owner's records. Users have no permissions on the
>table, but they have on the view.
>
>However, this method limits SELECT as well as UPDATE and DELETE. I
>want the user to be able to select all rows, but alter only a subset.
>How is that possible? UPDATE and DELETE triggers? Or is there any
>simpler way?
>
>Thank you.

this is easily accomplished via fine grained access control

http://asktom.oracle.com/~tkyte/article2/index.html

....

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp