From: John L. Turner <jlt@wvinter.net>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PGACCESS Error Relative Path @ export table
Date: Thu, 1 Aug 2002 08:35:09 +0000
Message-ID: <200208010835.09014.jlt@wvinter.net> (raw)
In-Reply-To: <1028159509.22663.70.camel@linda>
References: <HKEIIDPFPDBMOMDLIEEGAEMNCKAA.iavor.raytchev@verysmall.org>
<200207311445.05814.jlt@wvinter.net>
<1028159509.22663.70.camel@linda>
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 directories
> > > > ?
> > >
> > > This is at the OS level. Pgaccess is really only accessing the file via
> > > 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 you.
>
> ...
>
> > 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:
............. < formdemo.sql
Regards,
John
--
John
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jlt@wvinter.net, olly@lfix.co.uk
Subject: Re: PGACCESS Error Relative Path @ export table
In-Reply-To: <200208010835.09014.jlt@wvinter.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox