Re: [firebird-support] Re: How can I get a list of firebird db users?

2012-01-16 Thread Milan Babuskov
Trond wrote: If you use Firebird version = 2.1 you can use something like this: SELECT ma.MON$USER, ma.MON$REMOTE_ADDRESS,ma.MON$TIMESTAMP, ma.MON$REMOTE_PROCESS, ma.mon$attachment_id, ma.mon$attachment_name, ma.mon$role, ma.mon$state, ma.mon$stat_id,

Re: [firebird-support] Re: How can I get a list of firebird db users?

2012-01-12 Thread Trond
If you use Firebird version = 2.1 you can use something like this: SELECT ma.MON$USER, ma.MON$REMOTE_ADDRESS,ma.MON$TIMESTAMP, ma.MON$REMOTE_PROCESS, ma.mon$attachment_id, ma.mon$attachment_name, ma.mon$role, ma.mon$state, ma.mon$stat_id, ma.mon$server_pid,ma.mon$remote_pid

[firebird-support] Re: How can I get a list of firebird db users?

2012-01-11 Thread Ahmet Nuri D
I find one solition for that SELECT RDB$USER FROM RDB$USER_PRIVILEGES group by 1 --- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote: Ahmet Nuri D wrote: Hi, I want to list firebird user. can I do that? Start Firebird gsec tool with -display switch. Example on

Re: [firebird-support] Re: How can I get a list of firebird db users?

2012-01-10 Thread Thomas Steinmaurer
I am useing Lazarus and Lazarus own Ib connection components . Can't help you with Lazarus. I don't know what IB connection components Lazarus has included. Perhaps there are components exposing the Services API in particular for managing Firebird users. I recall that in IBX there was