Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fine-grained access stuff and preventing wrong inserts/updates...
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