Hello Stefan,

> Hallo all,
>
> 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?
>
> Using Firebird 2.5.3.26778 on Windows 7 Pro.

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.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.