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
FROM MON$ATTACHMENTS MA
WHERE ma.MON$ATTACHMENT_ID <> CURRENT_CONNECTION
Post by Helen BorriePost by Ahmet Nuri DI find one solition for that
SELECT RDB$USER
FROM RDB$USER_PRIVILEGES
group by
1
If it was that easy, someone would have told you about it. ;-)
All this gives you is a list of users (that may or may not exist) which
have SQL privileges assigned to them *in that database*. The security
database (where user accounts live) is not linked to user databases in
any way.
./heLen
--
Mvh
Trond Dammen
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/