|
From: | catmat |
Subject: | Re: [Gnumed-devel] Re: web frontend/patient singleton |
Date: | Sun, 30 Jan 2005 18:03:06 +1100 |
User-agent: | Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041231 |
catmat wrote:
this worked by first logging in as postgres then , grant all on public.pg_user to "gm-dbowner";but there is a sql command "set session authorization 'username'" if the original connectinguser is a superuser, so that could be the workaround.
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.
[Prev in Thread] | Current Thread | [Next in Thread] |