community.borland.com
Article #29889: User names and number.
Question:
How do I get the number and names of connected users?
Answer
One way is to use the TIBDatabaseInfo component that comes with Delphi. Another, more complicated way, is to use the InterBase services API. For more information using the InterBase services API see the "InterBase API Guide", chapter 12, "Working With Services".
Also, if you are using InterBase 7 you can get this information from the temporary table TMP$ATTACHMENTS. For more information on the information contained in TMP$ATTACHMENTS see the InterBase "Language Reference" chapter 7, "System Table, Temporary Tables, and Views".
Last Modified: 07-APR-03