Hello,

the new features of Firebird v2.5 to administrate the users with SQL
(CREATE, ALTER, DROP) are very welcome and work fine.

In order to present only those accounts that acctually exists I wonder
if there is a similar thing liek gsec display.

At the moment I am using that query (As suggested on
http://www.firebirdfaq.org/faq266/):
SELECT u.RDB$USER, u.RDB$RELATION_NAME
FROM RDB$USER_PRIVILEGES u
WHERE u.RDB$PRIVILEGE = 'M'
ORDER BY 1, 2

But this query shows also user accounts that were deleted before.

Question 1: Is there a method to get a list of all existing users ?
Question 2: Is it neccessary to maintain the table RDB$USER_PRIVILEGES
directly?

Thanks

Niko