Can this be done? It would be great to have some more system views/virtual
tables/whatever you call them in order to get these things done.

Does the engine keep track or running requests? How easy can they
(internally) be cancelled?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

> select rdb$start_time from rdb$requests;
>
> select rdb$request_id from rdb$requests
> where rdb$user = 'ROGUEUSER';
>
> delete from rdb$requests
> where rdb$request_id = 38;

Claudio

This sounds too simple, is it a practical way forward?

It sounds as if it could give 'performance time' information
such as

select rdb$start_time, rdb$request from rdb$requests where
rdb$start_time > 'NOW' - (2mins)

I presume that the missing bit is getting the 'delete' to
actually cancel the query?


[Non-text portions of this message have been removed]