0

I'm logged in as a user in postgres with PgAdmin tool in Linux connecting remotely but I don't think the user has enough rights. I'm a MySQL experienced user but not so much in PostGres. When I select a table when logged in as the user I get

An error has occurred:

ERROR: permission denied for relation acs_activities

how do I add my user "gainpm" to have access to all tables in "projop" database?

0

I figured it out. First I had to login as superuser

sudo -u postgres psql

then issue

ALTER USER myuser WITH SUPERUSER;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.