Query Trigger

Hi,

I have a table with one million records. When a user query the table, the result should produce depends on the user's privilieges to that table. For eg, the user might not view the certian records which are irrelevant.
I should use the same command "select * from table" for different users. The trigger should surpress the query result depends on the user.

Pls guide me.

Thanks. Received on Tue Jul 25 2006 - 02:09:16 CDT