Implementing Data-level Security

From: Anup Jalan <anupcomp_at_giasbm01.vsnl.net.in>
Date: 1997/02/10
Message-ID: <1.5.4.32.19970210044745.0066f07c@giasbm01.vsnl.net.in>#1/1

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 Jalan

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.in

INDIA

Received on Mon Feb 10 1997 - 00:00:00 CST