Hi,

> In commercial products as EMS QuickDesk or IBAdmin there is a tool called

Grant Manager, where one can set roles and assign users to that roles. I
know I can get role names with something like this:

>
> SELECT RDB$ROLE_NAME
> FROM RDB$ROLES
>
> How can I know if a User is assigned to a Role?. Is there a function like

GetRolesOfUser(User: String): TStrings?

Check the Language Reference, chapter System Tables and Views.

Table RDB$USER_PRIVILEGES is what you're looking for.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."