Subject RE: [ib-support] SQL ROLES
Author Martijn Tonies
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

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.


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