Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Cache
You might want to take a look of FGAC (fine grained access control)
and see if it can give you what you need. Basically you establish a
policy and link it to a table with dbms_rls.add_policy. And within the
function that implements that policy you decide how the policy should
work - which effectively alter your SQL statement. There have been
quite a few discussions on FGAC recently in this NG. You can do a
search to find out the issues and the problem related to update table
with CLOB field.
That said, don't do it just because you can. My feeling is that if you want to do it, you should do it from the beginning when you are building the apps, not after.
s.prochazka_at_artaker.com (Stefan) wrote in message news:<abd291f3.0211200649.50865831_at_posting.google.com>...
> I have an application which is communication via ODBC with an Oracle
> Database.
> This Application sends queries to the Database and processes the
> result(s).
> I have no access to the source code of this application.
> Is it possible to tell Oracle to modify incoming SQL - Queries and to
> return the modified result?
> For Example
> The Application sends:
> "Select * From x where A = 5"
> This should be modified to
> "Select * From x where A = 6"
> and the result should be taken from the second query.
>
>
> Any help would be appreciated...
>
> THXs,
>
> Stefan
Received on Wed Nov 20 2002 - 14:48:00 CST