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,
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
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
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