[Zope-DB] Per-user connections
Mon, 09 Dec 2002 11:01:18 -0000
Am I missing the bl***ing obvious here :-) ... but why can't you use
whatever is your normal Zope authentication and then pass
AUTHENTICATED_USER into your ZSQL methods for authorisation, auditing etc.
Oracle now recognises the difficulty of registering every possible user in
the database and e.g with the use of virtual private databases expects to
pick up user/authentication information from the context of each database
--On Monday, December 09, 2002 11:17:46 +0100 Yves Bastide
> M.-A. Lemburg wrote:
>> Just to understand this discussion: why are per-user connections
>> needed ?
>> Is it because you want to manage authentication for these
>> connections on a per-user basis ?
> Yes (authentication, authorisation, auditing)
>> From a technical point of view, it should be possible to
>> place a Zope connection object into a user or even session
>> object, since they are pickleable. Even transactions should
>> work, since each .query() call registers itself with the
>> The only point to watch out for is thread safety, since probably
>> not all DAs provide thread locks around the various method
> Zope-DB mailing list
Iain (Jethro) Anderson - DBA (ISYS) University of Bristol
Pigsty Morris City Clickers Step and Clog
Instep Research Team Insword Rapper
"Never give a sword to a man who can't dance"