Re: Accessing the database

Pragati,
    I am assuming that your webserver is running as user "nobody".  If
that is the case, then you need to make sure that the user "nobody" can
access the table.
    If your scripts only do selects on the table, then this command
would do the trick

GRANT SELECT on table1 to nobody;

    Check the docs on the GRANT command, you may need to give user
nobody more provledges than SELECT, if your scripts are doing other things
than SELECT...

http://www.postgresql.org/docs/user/sql-grant.htm

    Also, make sure that the user nobody exists.  You may need to add
this user too from a postgres superuser account...

http://www.postgresql.org/docs/user/sql-createuser.htm

Hope this helps,
    Daryl


On Fri, 2 Jun 2000, Pragati Sagar wrote:

~|Hi!
~|I connecting the postgreSQL database through the following code:
~|
~|<?
~|$conn=pg_connect("<IP address>","<port>","","","<database>");
~|$index=pg_exec($conn,"select * from table1");
~|?>
~|
~|On execution of this code from the browser, following error appears :
~|
~|Warning: PostgresSQL query failed: ERROR: table1: Permission denied. in
~|/home/httpd/html/script.php3 on line 8
~|
~|Where am I going wrong? Does the code have a problem or there is something
~|wrong with the permissions.
~|Please help me out.
~|
~|Thanks
~|Pragati
~|