Re: Permission on tables - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: Permission on tables
Date
Msg-id NEBBLAAHGLEEPCGOBHDGOEMHENAA.nickf@ontko.com
Whole thread Raw
In response to Re: Permission on tables  ("Steven Cuthbertson" <steven@tie.cl>)
List pgsql-admin
Steve

Have you tried connecting just using psql to make sure you've got
authorization working over the network? It kind of sounds like that might
the the issue.

-Nick

> -----Original Message-----
> From: Steven Cuthbertson [mailto:steven@tie.cl]
> Sent: Friday, April 26, 2002 2:24 PM
> To: nickf@ontko.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Permission on tables
>
>
> The user is running under tha name "apache". I tried creating the
> user "apache"
> in pgsql and granting permission to that user, but that didn't
> work either,
> which I find strange. It would seem that life is MUCH easier if Apache and
> Postgres are installed on the same host, but that's not the case...
>
> I'm reinstalling the apache machine now anyway, because I don't like the
> way RH installed the rpm's
>
> Steve
>
> >-- Original Message --
> >Reply-To: <nickf@ontko.com>
> >From: "Nick Fankhauser" <nickf@ontko.com>
> >To: "Steven Cuthbertson" <steven@tie.cl>,
> >    <pgsql-admin@postgresql.org>
> >Subject: Re: [ADMIN] Permission on tables
> >Date: Fri, 26 Apr 2002 09:24:55 -0500
> >
> >
> >
> >>      grant ALL on mytable to PUBLIC;
> >>
> >> Q: Is this dangerous? What is encompassed by "ALL"? Read? Write?
> >
> >Sounds unwise to me, but I'm not a PHP-er.
> >
> >In the Tomcat/Apache world, I can tell you that we generally grant select
> >on
> >mytable to "www-data".
> >"www-data is the user that Apache runs as by default. I'd suggest finding
> >the Apache or PHP user & then granting only those privileges
> needed to only
> >that user.
> >
> >Are you sure that you aren't just getting a more general
> rejection of your
> >connection due to problem in pg_hba? You mention that the servers are
> >separated. You could test the connectivity & authorization from X to Y by
> >trying (from X) psql -hY
> >
> >regards,
> >
> >-Nick
> >
> >---------------------------------------------------------------------
> >Nick Fankhauser
> >
> >    nickf@doxpop.com  Phone 1.765.965.7363  Fax 1.765.962.9788
> >doxpop - Court records at your fingertips - http://www.doxpop.com/
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
>
>
>
> ________________________________________
> Obtenga su direccion de correo en http://www.internetempresas.cl
>
>


pgsql-admin by date:

Previous
From: Lucas Rockwell
Date:
Subject: smart copy?
Next
From: "Joel Burton"
Date:
Subject: Re: smart copy?