postgreSQL user permission denied

[monkeyxu]

Hi, all

I am new for psql and here is my problem.
I created a new psql user with no superuser no role creation and no DB creation. So when the new user tries to query a table and got:

postgis_test_db => SELECT vessel_name, time, position FROM current_positio n;
postgis_test_db => ERROR: permission denied for relation current_positio n

Any suggestions will be greatly appreciated

Yuan

[rski]

Hi, all

I am new for psql and here is my problem.
I created a new psql user with no superuser no role creation and no DB creation. So when the new user tries to query a table and got:

postgis_test_db => SELECT vessel_name, time, position FROM current_positio n;
postgis_test_db => ERROR: permission denied for relation current_positio n

Any suggestions will be greatly appreciated

Yuan

User have no permittions for the table curent_position . Grant a select permission to this user .