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.
