sabeer.oracle_at_gmail.com wrote:
> 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.
You could have a look at Application Contexts. A link to documentation:
http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvpoli.htm#sthref2219
Received on Tue Jul 25 2006 - 04:19:20 CDT
