When i am runing mu insert query too insert into database i am getting an error message like .. ERROR: permission denied for relation advertiser_regidetdir
How will i resolve this? thanks
A:
You don't have permissions to do an INSERT, use GRANT to change this. You must have access to a role that is either superuser or object owner.
http://www.postgresql.org/docs/current/interactive/sql-grant.html
Frank Heikens
2010-09-09 11:53:52
can i give permission like mysql or how will i give Grant permission command?
Ajay_kumar
2010-09-09 12:16:03
Did you check the manual? GRANT INSERT ON TABLE your_table_name TO database_user_name; It's all in the manual, you can find the url above.
Frank Heikens
2010-09-09 13:09:08