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