Hi,

> I need to find out the current role from inside a trigger in IB 6... Is
> that possible? If not (as I fear) can you think of any other way to set
> a connection-local variable that will be visible from inside my trigger?

No and no.

Unless you would create a table that holds the "current role", which
you set from your application.

This - obviously - only works if you're using unique user names.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com