Permission denied for relation

Question

I tried to run simple sql command   select   from site adzone    and I got this error  ERROR   permission denied for relation site adzone   What could be the problem here   I tried also to do select for other tables and got same issue  I also tried to do this   GRANT ALL PRIVILEGES ON DATABASE jerry to tom    but I got this response from console  WARNING   no privileges were granted for  jerry    Do you have some idea what can be wrong

User · Answer

This frequently happens when you create a table as user postgres and then try to access it as an ordinary user  In this case it is best to log in as the postgres user and change the ownership of the table with the command   alter table  lt TABLE gt  owner to  lt USER gt

User · Answer

As you are looking for select permissions  I would suggest you to grant only select rather than all privileges  You can do this by   GRANT SELECT ON  lt table gt  TO  lt role gt

User · Answer

1st and important step is connect to your db   psql -d yourDBName   2 step  grant privileges  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO userName

User · Answer

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public to jerry  GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to jerry  GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to jerry

User · Answer

Connect to the right database first  then run   GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO jerry

User · Answer

You should    connect to the database by means of the DBeaver with postgres user on the left tab open your database open  Roles tab dropdown select your user on the right tab press  Permissions tab  press your schema tab press tables tab dropdown select all tables select all required permissions checkboxes  or press Grant All  press Save

User · Answer

Posting Ron E answer for grant privileges on all tables as it might be useful to others   GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO jerry

User · Answer

Make sure you log into psql as the owner of the tables  to find out who own the tables use  dt  psql -h CONNECTION STRING DBNAME -U OWNER OF THE TABLES  then you can run the GRANTS

User · Answer

GRANT on the database is not what you need   Grant on the tables directly   Granting privileges on the database mostly is used to grant or revoke connect privileges   This allows you to specify who may do stuff in the database if they have sufficient other permissions   You want instead    GRANT ALL PRIVILEGES ON TABLE side adzone TO jerry    This will take care of this issue

User · Answer

To grant permissions to all of the existing tables in the schema use   GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA  lt schema gt  TO  lt role gt    To specify default permissions that will be applied to future tables use   ALTER DEFAULT PRIVILEGES IN SCHEMA  lt schema gt     GRANT  lt privileges gt  ON TABLES TO  lt role gt     e g   ALTER DEFAULT PRIVILEGES IN SCHEMA public    GRANT SELECT  INSERT  UPDATE  DELETE ON TABLES TO admin    If you use SERIAL or BIGSERIAL columns then you will probably want to do the same for SEQUENCES  or else your INSERT will fail  Postgres 10 s IDENTITY doesn t suffer from that problem  and is recommended over the SERIAL types   i e   ALTER DEFAULT PRIVILEGES IN SCHEMA  lt schema gt  GRANT ALL ON SEQUENCES TO  lt role gt     See also my answer to PostgreSQL Permissions for Web App for more details and a reusable script   Ref    GRANT  ALTER DEFAULT PRIVILEGES

[postgresql] Permission denied for relation

Examples related to postgresql

Examples related to privileges

Examples related to postgresql-9.2

Examples related to grant