"ezra epstein" <ee_newsgroup_post@prajnait.com> writes:
> Basically I want a login user that can then set session auth... to any other
> user but otherwise has no privs.
You have not thought this through.
If user X can become any other user Y, then he can do anything that is
doable within the system. Pretending that he is not superuser is
pointless.
regards, tom lane