Content-Type: text/plain;
  charset="iso-8859-1"
From: "John L. Turner" <jlt@wvinter.net>
Reply-To: jlt@wvinter.net
Organization: JCI Inc.
To: Oliver Elphick <olly@lfix.co.uk>
Subject: Re: PGACCESS Error Relative Path @ export table
Date: Thu, 1 Aug 2002 08:35:09 +0000
User-Agent: KMail/1.4.2
References: <HKEIIDPFPDBMOMDLIEEGAEMNCKAA.iavor.raytchev@verysmall.org>
	<200207311445.05814.jlt@wvinter.net>
	<1028159509.22663.70.camel@linda>
In-Reply-To: <1028159509.22663.70.camel@linda>
Cc: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200208010835.09014.jlt@wvinter.net>

Oliver Elphick, wanted me to know...
> On Wed, 2002-07-31 at 15:45, John L. Turner wrote:
> > > > SO that leads to the bottom line Question:
> > > > How does a user in postgresql obtain permissions to other directori=
es
> > > > ?
> > >
> > > This is at the OS level. Pgaccess is really only accessing the file v=
ia
> > > the filesystem of the OS that you are running. You need to make sure
> > > that the user you start PGAccess with has permissions for those
> > > files/directories. For example, on Unix machines, you would use chmod.
> > > If you are on a machine that is maintained by someone else, then you
> > > would need to ask that person to set the permissions correctly for yo=
u.
>
> ...
>
> > 3) I started pgaccess as user jlt ( normal user me ). @  /home/jlt
> >    Within pgaccess, USERS tab, I added jlt (me) as a user.
>
> Your own user name is irrelevant, because it is not you but the backend
> which is trying to write the file.  Therefore the relevant user is
> 'postgres' (if that is the user that started the postmaster).

Thank you for the reply !

Final question on that subject would be:

What is the purpose of the List of users that is set in:
             pgaccess [ Tab: Users ] ?

I noted that postgres is not in that list in the demo database supplied:=20=
=20=20=20=20=09=20=20=20=20
.............  <    formdemo.sql=20=20

Regards,
John


--=20
John=20