Disable some queries of a application

[Zargo]

Hi all,

Is it possible to disable some queries from an application. The application is doing a huge UDATE query which i want to disable. All other queries from this application is ok. We can't change the coding of the application.

Is it possible that we can disable some queries from this application?

Any idea is appreciated

 

[SantaMufasa]

Zargo,

Typically, one cannot disable code pieces of an application...that would certainly be an audit exception.

You said that you want to disable a specific UPDATE statement...do you want to allow/disallow the application user to UPDATE rows from other points in the application?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[Welshbird]

Or indeed is this the only update on a particular table - if so you could just not allow updates on that table for this user.



Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]