Hi Nols,

> Hi,
>
> How do I get a list of users, stored in security2.fdb, in a FireBird's role?

Well, users in security2.fdb are instance-wide, while roles are specific
to a database. What you can query is a list of users and their role
membership for the connected database with:

select
rdb$user as user_name
, rdb$relation_name as role_name
from
rdb$user_privileges
where
rdb$privilege = 'M'
order by
rdb$relation_name
, rdb$user


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/