Online Documentation for SQL Manager for InterBase/Firebird

Viewing users

The Users tab of Database Monitor allows you to view the list of users logged in since the current connection was opened.

The list displays the users as a grid with the following columns:

ID, User, State, Login time, Pool memory, Host, IP address, Process ID, Quantum, Priority, Compiled statements, Active transactions, Active sorts, DB key ID, Page reads, Page writes, Page fetches, Page marks, Record selects, Record inserts, Record updates, Record deletes, Record purges, Record expunges, Record backouts (for InterBase);

ID, User, Role, State, Login time, Server PID, Remote PID, State, Remote protocol, Remote address, Charset ID, Garbage collection, Compiled statements, Active transactions, Active sorts, DB key ID, Page reads, Page writes, Page fetches, Page marks, Record selects, Record inserts, Record updates, Record deletes, Record purges, Record expunges, Record backouts (for Firebird).

If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Users management tools are available through the Navigation bar and toolbar of Database Monitor.