Re: Customizing Oracle Query Handling

grp.anon_at_gmail.com wrote:
> Hi there,
>
> Is it possible to intercept queries on the Oracle Server prior to
> processing and encompass some rules around how the queries are
> processed?
>
> For e.g. Depending on varying parameters I may want to deny users
> querying capabilities or forward them to another instance or modify
> queries based on hints contained in the queries etc.
>
> Is it possible to do this kind of query management in Oracle? I guess
> I essentially want to wrap some logic behind how/when queries are
> responded to by my oracle database. Can I embed oracle into a custom
> application to do something like this?
>
> I have been unable to find something relevant to this, I'm sorry if
> this is a repeat. Any help appreciated.
>
>
> Thanks very much,
>
> GrpAnon

At least a subset from your requirements could be done. Check concepts using virtual private database and fine-grained access control
You can start for example here
http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvpoli.htm

Gints Plivna
http://www.gplivna.eu Received on Fri Nov 17 2006 - 19:58:34 CET