Hi,

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?

Thanks.

Thomas Clarke


[Non-text portions of this message have been removed]