Re: How to "catch" SELECT

In article <3281c4c8.14618169_at_193.2.236.10>, Dussan Pirc <dussan.pirc_at_mop.sigov.mail.si> wrote:
>Hi!
>
>Another small problem - how to "cathc" SELECT state? With trigers you
>can DML states, but how can SELECT?
>
>I want to restrict some ROWS from some users - I wish that some users
>can't select all rows.... And I want to be implemented somewhere in
>server not in application...
>
>Any sugestions are vey welcome...
>
>Dussan

This may not be the best solution, but you could try creating a view that restricts the rows and grant the users access to the view and not the underlying table.

I did something similar at my last job (so I can't get any examples for you, sorry). Since my view was on a single table, I could also insert rows into the view.

I hope this suggestion helps...
paul Received on Fri Nov 08 1996 - 00:00:00 CET