[Zope] AUTHENTICATED_USER in zsql db connections?

[Jim Rowan]

I have a database that has security and logging built in -- (It's a
postgresql installation); certain people are allowed to update and others are 
only allowed to read -- and when people update, we keep track of who changed
what. 

I'd like zope to pass through the AUTHENTICATED_USER to the database -- so
that the database log will show who did the update/delete/insert just as it
does if we use some other interface.

I think that means that I want AUTHENTICATED_USER to be part of the database
connection string, and that I want each user to use a different instantiation 
of the connection... 

Is there any way to accomplish this?  (I tried the obvious, making the
connection string be
	dbname@localhost AUTHENTICATED_USER
; that didn't work... :)


Jim Rowan			DCSI	        DCE/DFS/Sysadmin Consulting
jmr@computing.com                                            (512) 374-1143