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

<grp.anon (AT) gmail (DOT) com> schreef in bericht
news:1163734750.754399.106650 (AT) h48g2000cwc (DOT) googlegroups.com...
Your kidding, right?

grp.anon (AT) gmail (DOT) com wrote:
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/c...6/apdvpoli.htm

Gints Plivna
http://www.gplivna.eu

Gints Plivna wrote:
And, additionally, ADVANCED REWRITE.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org