Re: [Gnumed-devel] Re: web frontend/patient singleton

[Karsten Hilbert]

> >but there is a sql command "set session authorization 'username'" if 
> >the original connecting user is a superuser, so that could be the workaround.
> >
> this worked by first logging in as postgres then, grant all on 
> public.pg_user to  "gm-dbowner";
> only needs to be done once.
> 
> thereafter ,  the initial connection pooling user can be gm-dbowner,
> who then can do ' set session authorization to "any-doc" ' if any-doc is the
> session user in tomcat.
I would, however, suggest setting up a dedicated connection
pooling user which is used to connect the pool and then set
session authorization.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346