Hi there,

take a look at the RDB$ROLES and RDB$USER_PRIVILEGES tables.

The Language Reference lists meaning of columns

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com




Is it possible to retrieve a list of roles for a specific user using
an SQL statement. What I am trying to do is, given a user name,
retrieve a list of available roles just for that user.

Martin


[Non-text portions of this message have been removed]