How to get a list of database users?
  • A list of connected users or even a list of all existing accounts in the system? - kirelagin
  • Kirelagin, the best accounts in the system. - Julien Sorel

1 answer 1

Interbase SQL Server supports several user authentication methods:

  • Interbase system database - admin.ib (isc4.gdb).
  • Embedded User Authentication - users and passwords are stored in the client's database. Copying of the admin.ib on server.

+

In isc4.gdb / admin.ib is the main table USERS, which stores the user name, password, and other parameters.

+

among the system tables of the ODS 11.2 database there is always the RDB $ USERS table. This is the equivalent of the USERS table from admin.ib

Russian quotes from here .