-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 2001 December 1 04:34 am, Yuri A. Kabaenkov wrote:
> How can i create user which users password authrization and can
> access/modify/drop/create all these database.
>
> Create languages on databases and so so so.
Sounds like you want a super-us
Hello,
I have some databases and pg_hba.conf with this content:
local dialer passworddialer
hostdialer 127.0.0.1 255.255.255.255 passworddialer
local helltop passwordhelltop
hosthelltop 127.0.0.1 255.255.255.255 passwordhellt
On Thu, 16 Mar 2000, Mike Edwards wrote:
> I am using PostgreSQL with PHP/Apache. PHP connects to Postgres as
> Linux user "nobody" (the user running the Apache daemon) unless a
> username and password is explicitly supplied. But I would like to let
> user "nobody" connect to a database not own
Wow! I didn't expect such good-natured responses! Almost immediately
after my first post, I remembered the whole GRANT issue and posted a
retraction--which I guess was unnecessary. (I expected a storm of
RTFMs, etc. after realizing my oversight.)
I appreciate the responses though, and they spu
Hi,
You just need to grant previlige SELECT to the user nobody on those tables.
check SQL command grant.
--
Bangh
Mike Edwards wrote:
> Hello all,
> My apologies if this has been covered here, but the archives are choking
> and TFMs don't seem to cover this too deeply.
> I am using PostgreSQL
It sounds like you need to check out how to GRANT permissions.
while in the db:
GRANT SELECT ON TO NOBODY
That's off of the top of my head, but should provide enough to point you in
the right direction.
At 09:45 AM 3/16/2000 -0600, Mike Edwards wrote:
>Hello all,
>My apologies if this has b
Check out the GRANT command in postgres; you'll want to do something like:
CREATE USER nobody WITH PASSWORD ;
GRANT SELECT ON , TO nobody;
However, I like to use suExec under apache to have things run by a
different user; that offers somewhat more security. I have scripts that
need, for exampl
Please disregard my previous post as there was no reason for me to be
hasty. I believe I have found the problem--it lies between my ears.
Also, please refrain from flaming me as I will be too busy flogging
myself with thorn bushes to reply.
Humbly,
Mike
--
Mike Edwards, MIS
Edwards Graphic Ar
Hello all,
My apologies if this has been covered here, but the archives are choking
and TFMs don't seem to cover this too deeply.
I am using PostgreSQL with PHP/Apache. PHP connects to Postgres as
Linux user "nobody" (the user running the Apache daemon) unless a
username and password is explicitl
