samuvk

I have the following configuration to connect to the database: $db_username = 'user=myuser'; $db_password = 'password=mypass'; $db_name = 'dbname=test'; $db_host = 'host=localhost'; $db = pg_connect("$db_host $db_username $db_password $db_name"); $query = "SELECT * FROM cities"; $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . "<br/>"; echo pg_last_error(); exit(); } $myrow = pg_fetch_assoc($result); $city = $myrow[city]; echo $city; The previous code works and it prints the name of the city in the table cities. Now If I try with the same but another table(Menu) which also have the field city I get the following error: Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation menu in /home1/user/public_html/index.php on line 9 Problem with query SELECT * FROM menu ERROR: permission denied for relation menu Both tables are under the same database (test) which was created by the same user. I don't know if I need to grant access to each table to the user and how or why am I getting this error. (When I run this in my computer it works but once I uploaded to the web that the error I'm getting) Any help would be highly appreciated.