Subject Re: [firebird-support] How to determine Role of attached user?
Author Stefan Heymann
>> when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
>> owner), the MON$ROLE field always shows 'NONE', even when the user is
>> logged in with a specific role.
>> Is there a way to find out the role another user (with a specifid
>> attachment_id) is logged in?

> AFAIR, the MON$ROLE field only provides a valid role name, when the
> user was a member (GRANT <role> TO USER <user>) of that role at connect time.

Thanks. That - of course - did the trick. Always a good idea to grant
a role to a user that wants to use it ;-)