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?