Re: [ADMIN] Accessing the database

2000-06-02 Thread Daryl Herzmann
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

Re: [ADMIN] Accessing the database

2000-06-02 Thread Jan T. Kim
On Fri, Jun 02, 2000 at 04:35:29PM +0530, Pragati Sagar wrote: > Hi! > I connecting the postgreSQL database through the following code: > > $conn=pg_connect("","","","",""); > $index=pg_exec($conn,"select * from table1"); > ?> > > On execution of this code from the browser, following error app

[ADMIN] Accessing the database

2000-06-02 Thread Pragati Sagar
Hi! I connecting the postgreSQL database through the following code: ","","","",""); $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/sc