Re: security question

In article <1995Feb17.102642.4006_at_inet.d48.lilly.com>

           swisshelm_at_lilly.com "Bob Swisshelm" writes:

:
: Here is the view on customer that limits what the users can see. Since
: the view is only on customer, they can do updates through it.
:
: create view secure_customer
: as select * from customer
: where distr in (select distr from security
: where username = user)

Better, in general, to use an EXISTS correlated subquery though otherwise you may find that all your queries against the view drive from the security table.

-- 
Jonathan Lewis