Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Implementing Data-level Security
Martin Smith <mfsmith_at_erols.com> wrote:
>Someone else will have to give you the specifics, but you can implement
>a trigger that provides row-level access control, so that user JJONES
>can only access rows that contain a column Salesman with a value
>"JJONES" (or presumably a column Region with a value "East" if there's
>another table that relates JJONES to the East region).
My original post did not give my requirements clearly. I want the users to SELECT as well as INSERT/UPDATE/DELETE from the views. Therefore, triggers are obviously not the way out.
Anup.
Anup Computers Tel : 91-22-364 7992 33, Shankar Sagar Fax : 91-22-363 6176 Sophia College Road Bombay 400 026 email : anupcomp_at_giasbm01.vsnl.net.inINDIA