PostgreSQL ERROR: permission denied for relation users

Problem: ERROR: permission denied for relation users

Solution:

How to show schema_name:
Connect to your database
type:

\dt

and then execute grant command:

GRANT ALL PRIVILEGES ON DATABASE name_db TO remote_user;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA <schema_name> TO <username>;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA <schema_name> TO <username>;