It sounds like you need to check out how to GRANT permissions.

while in the db:

GRANT SELECT ON <tablename> 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 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
>
>
---------------------------------------------------------------
 Edward F. Chase III     |   [EMAIL PROTECTED]
 Providence College      |   http://www.providence.edu
 Computer Services       |   http://studentweb.providence.edu
 Providence, RI  02918   |

Reply via email to