""Dimitry Sibiryakov"" <SD@...> wrote in message
news:3C7B645E.16591.60BA56@localhost...

>
> Much more useful could be a way to see queries, running
> on the server and to cancel any of them.

I think that it could be useful to define a global quanta for request. If
that quanta is reached, query is cancelled automatically.
Now, for your feature, we could have a virtual system table do to
interesting things:

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;

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing