Symptoms

The error may occur during the import into a PostgreSQL database.

Causes

This error message appears if you are not the owner of the table or the owner has not granted you the necessary permissions. Depending on what authentication methods (trust, md5, etc. ) you have set, you may receive the following error when trying to work with a particular table. This is usually caused by creating a table as user 'postgres', and then trying to use it as user 'bob'.

Solutions

There are two solutions to this problem:

1. Change the owner of the table to the user you need. You will need to log in as the current owner or superuser account and execute

ALTER TABLE table_name OWNER TO new_owner_name.

1. You can also GRANT other users access to this account using GRANT ALL ON table_name TO user_name. Note: this will give the user full select, insert, update, and delete access from this table. You can limit their access to SELECT access using

GRANT SELECT ON table_name TO user_name.

If you encounter any difficulties or have additional questions, please contact us at support@ispirer.com.