Re: Customizing Oracle Query Handling
From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 19 Nov 2006 09:48:22 -0800
Message-ID: <1163958514.60302_at_bubbleator.drizzle.com>
>> 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
Date: Sun, 19 Nov 2006 09:48:22 -0800
Message-ID: <1163958514.60302_at_bubbleator.drizzle.com>
Gints Plivna wrote:
> 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
And, additionally, ADVANCED REWRITE.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Nov 19 2006 - 18:48:22 CET