Hi,
I need a way to intercept and modify SQL statement with parameters
sent by .NET application. It should be transparently, I mean I don't
want application to be recompiled. Is there any simple way to do this?
Thanks

On Jul 28, 6:19*pm, Zabuti Maxim <zabutima... (AT) gmail (DOT) com> wrote:
Off the top of my head I would say, "no, there is no way to do this."
However, if you provide a more complete explanation of what you want
to do with the SQL, why, and the front-end application design and tool
set someone may be able to offer useful suggestions.

HTH -- Mark D Powell --

Zabuti Maxim (zabutimaxim (AT) gmail (DOT) com) wrote:
: Hi,
: I need a way to intercept and modify SQL statement with parameters
: sent by .NET application. It should be transparently, I mean I don't
: want application to be recompiled. Is there any simple way to do this?
: Thanks

You could send it thru a proxy. There are probably examples on someplace
like sourceforge.

Writing one to monitor the data being passed back and forth is pretty easy
- editing the data as it goes thru would be trickier.

$0.10

On Jul 29, 6:27*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:

Thanks Malcolm,

I thought about an option to develop a proxy that will receive the
packets, parse them, modify and send them to SQL server,
but this way is pretty complicated one, I thought maybe there is some
way to hook SQL + Parameters that pass between the application
and OLEDB driver or between application and ADO.NET.
Unfortunately, I can't talk about the reasons.

Thanks again.

Zabuti Maxim schreef:
There is nothing more simple than that. Oracle calls it their VPD:

http://www.oracle.com/technology/obe...ty/vpd/vpd.htm

On Jul 30, 10:59*am, "Gerard H. Pille" <g... (AT) skynet (DOT) be> wrote:
That only places a very limited modification to see a subset of the
data or audit actions. If the secret reasons the OP can't talk about
aren't that, it's not applicable. Also see Pete Finnegan's VPD
security pdf and various other row level security docs on the net, as
well as special code needed for things like weblogic and bugs with
some tools. http://download.oracle.com/docs/cd/B...i.htm#CHDECFBF
for how it applies to different access models. There's other things
like sys being exempt, you need to make others exempt to get a
complete export, parsing and optimizer issues can occur (sometimes
things may go faster if the data is limited properly - but additional
administration is necessary regardless), and a lot of other more
obscure issues may need to be addressed.

jg
--
@home.com is bogus.
http://www.xconomy.com/san-diego/200...he-web-part-2/