Firebird Documentation Index → Firebird 3.0.6 Release Notes → Security → Pseudo-Tables with List of Users |
To access lists of users and attributes, query the virtual tables SEC$USERS and SEC$USER_ATTRIBUTES.
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.
Firebird Documentation Index → Firebird 3.0.6 Release Notes → Security → Pseudo-Tables with List of Users |