> ok!
> This works for all the roles:
> select rdb$role_name
> from rdb$roles
>
> but, I still can't get the relation between roles and users.

select
rdb$relation_name as role_name
from
rdb$user_privileges
where
rdb$privilege = 'M'
and rdb$user = <your_user>


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com