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: Fine-grained access stuff and preventing wrong inserts/updates...

Re: Fine-grained access stuff and preventing wrong inserts/updates...

From: Spendius <spendius_at_muchomail.com>
Date: 6 Feb 2006 05:01:47 -0800
Message-ID: <1139230907.853283.16610@f14g2000cwb.googlegroups.com>


Merci mille fois, c'est splendide.

Internally, Oracle adds the WHERE clause you've defined OK ? ("AND AREA = <value specified in context>")

Have you ever encountered cases where forgetting indexes on the filter column(s) had an impact on the statements involving all these security policies configuration ?

Encore merci !

> So you get one view definition, which always shows the
> correct data for the user, one table trigger which always
> get the right data onto the table, and one logon trigger
> that sets the correct context for all users.
>
>
Received on Mon Feb 06 2006 - 07:01:47 CST

Original text of this message

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