Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15561; Sun, 26 Apr 92 19:59:08 -0700
Date: Sun, 26 Apr 92 19:59:08 -0700
Message-Id: <9204270259.AA15561@postgres.Berkeley.EDU>
From: Sean.Levy@cs.cmu.edu
Subject: Who am I?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

When connecting to a backend via libpq from a remote host, who does the
backend think I am? I want to define rules that disallow access to
instances based on attributes of those instances, depending on the user
trying to do the retrievals; thus, I need some way to know who the user
performing the query is. The manual claims that pg_username() returns
the user name of the "current user" (define rule man page), but what
does that mean? Does libpq transmit the UID of the user? If the remote
user's number UID is not one of the ones in the system catalogs (entered
via createuser, I assume), then are libpq connections disallowed?

Also, is there a way to get rid of a rule? I don't want to start mucking
about with thes and find I can't unmuck.

Enquiring minds want to know...
			-- Sean
--
Sean Levy <snl+@cmu.edu>		   `... from intuition we can pass to
CMU Engineering Design Research Center      analysis, but not from analysis to
ndim Group                                  intuition.' --Henri Bergson
                      <--  Standard Disclaimers Apply  -->