Re: HELP: Row Level Security

From: <KJOHNSON_at_ESRIN.BITNET>
Date: Wed, 13 Jul 1994 11:12:24 CET
Message-ID: <94194.111225KJOHNSON_at_ESRIN.BITNET>

Try using a view
e.g. CREATE VIEW viewname

        AS SELECT * FROM tablename
        WHERE col = value

ÝIf you require the user to update the table, you can use the  'WITH CHECK OPTION' to validate the rows inserted/updated through the view  can subsequently be queried by the view. Regards, Kevin.

---

Kevin Johnson                      EMAIL  :  johnson_at_mail.esrin.esa.it
Information Administrator          PHONE  :  (+39) 6 941 80 633

European Space Agency
ESRIN, FRASCATI, ITALIA. Received on Wed Jul 13 1994 - 12:12:24 CEST