"Martijn Tonies" <martijn@...> wrote in message
news:D09B3AA2992AD611AA5200AA004126EEDE44@SRV_BISIT...

>
> What about a views with:
>
> - connected users

Connected users is the same info that you can get through isc_database_info,
provided that you don't get a truncated list, of course. :-)
(Thread "User list truncated").
Of course, with that, you get a list, not that you are going to change
anything.

> - queries (states: preparing, busy (ordering etc), fetching, suspended)

The state may be so volatile that I don't know if it's a performance hog to
maintain it. Our prepare phase is really fast.

> - processes (users, threads, sweep, backup, etc?)

Provided that you don't want to see thread in Classic. <g>
Backup is no more than gbak connected with a special dpb. Anybody can lie
and pretend to be gbak.

> Deleting from connected users would really disconnect,

How is this different than to take the db in single user mode with gfix?
That you want to drop only specific users?

> SYSDBA and DB owner only? How hard would it be for a non-C
> programmer (me) to get these kind of things started?

To get what started? I don't get the idea. To do client-side support or to
get your hands inside the engine's code?

> How
> hard would it be to create these kind of views, Claudio??

It depends on how much money the community wants to chip-in for this humble
developer, Martijn.
:-)

> And is it possible to create users via SQL statements (SYSDBA
> only?) instead of the (juk) services API? How hard would this
> be?

AFAIK, Greg Deatz was exploring those roads in his FreeUDFLib. He built a
function so anybody could change his/her own pw, without sysdba.

It seems that people really hate the Services API. What's the exact reason?

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