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 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 owned by "nobody". Do I do this
> using groups and a POstgres user "nobody", and if so, can I restrict
> access with read-write vs. read-only privledges?
>
> Or is the short answer to create my databases as user "nobody"?
>
> Thanks!
> Mike
>
> --
> Mike Edwards, MIS
> Edwards Graphic Arts, Inc.
> 2700 Bell Avenue
> Des Moines, IA 50321
