Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Trigger
sabeer.oracle_at_gmail.com wrote:
> 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.
Use different schemas, create views with the same name in each that select the desired subset.
Yours,
Laurenz Albe
Received on Tue Jul 25 2006 - 02:42:12 CDT