By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

postgreSQL user permission denied

P: 2
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_position;
postgis_test_db=> ERROR: permission denied for relation current_position


Any suggestions will be greatly appreciated

Yuan
Oct 25 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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_position;
postgis_test_db=> ERROR: permission denied for relation current_position


Any suggestions will be greatly appreciated

Yuan
User have no permittions for the table curent_position. Grant a select permission to this user .
Oct 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.