Firebird Documentation IndexFirebird 3.0.6 Release NotesSecurity → Pseudo-Tables with List of Users
Firebird Home Firebird Home Prev: SQL Features for Managing AccessFirebird Documentation IndexUp: SecurityNext: Restriction on DROP ROLE (v.3.0.1)

Pseudo-Tables with List of Users

CORE-2639.

To access lists of users and attributes, query the virtual tables SEC$USERS and SEC$USER_ATTRIBUTES.

Important

This feature depends highly on the user management plug-in. Take into an account that some options are ignored when using the legacy user management plug-in.

The pseudo-tables are much like the MON$ family tables used for monitoring the server. The table is created on demand when you run the statement

  SELECT * FROM SEC$USERS
    

or

  SELECT * FROM SEC$USER_ATTRIBUTES
    

The output lists the users (or their attributes) in the security database that is configured for the current database and available for management to the current user. SEC$USERS includes a field indicating whether a user has the RDB$ADMIN role in the security database.

Prev: SQL Features for Managing AccessFirebird Documentation IndexUp: SecurityNext: Restriction on DROP ROLE (v.3.0.1)
Firebird Documentation IndexFirebird 3.0.6 Release NotesSecurity → Pseudo-Tables with List of Users