We use Firebird/Interbase with Zope on several systems. Unfortunately Zope logs in
with one connection and so its hard to equate a web-login to an SQL request.

What would be interesting is being able to specify a userid PER TRANSACTION,

so when I call begin(), I can pass in the userid to use..

Maybe this is the place to do it, not in a table trigger. This would require changes in the
client and protocol, but I think would be more generally useful because it would apply to
any transaction, not just to a table.

I have no idea if its technically possible.



Brad Clements, bkc@... (315)268-1000
http://www.murkworks.com (315)268-9812 Fax
netmeeting: ils://ils.murkworks.com AOL-IM: BKClements