Hello Thomas,

> I am using a 2.5 superserver database accessed from a Delphi application. I
> want to allow a master user to add, modify and delete users. I can use the
> create user, alter user and drop user SQL commands for this. My problem is I
> want to list all current users of the database in a grid. I found the
> following query:
>
> select distinct rdb$user
> from rdb$user_privileges
>
> But it displays users after they have been dropped.
>
> Does anyone know of a query that can list the users of a database from the
> system tables?

Users are stored instance/server wide in a database called security2.fdb.

What you are querying are the privileges on database objects (tables,
views, ...) granted to users/roles/procedures for the database you are
currently connected to.

Use the command-line tool gsec to get the available users for the
instance/server located in the Firebird bin directory.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!