Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query Trigger

Re: Query Trigger

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 25 Jul 2006 07:42:12 GMT
Message-ID: <1153813331.109935@proxy.dienste.wien.at>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US