Hi,

> Yes, the answer was in Table RDB$USER_PRIVILEGES.
>
> If one user is assigned to a role then that user will appear in field RDB$USER and the role name in RDB$RELATION_NAME. Is
> this true?

I'm using the following query to get the users, who are members
of a given role.

select rdb$user from rdb$user_privileges
where (rdb$relation_name='YOURROLE') and (rdb$privilege='M')
order by rdb$user


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com