databasepostgresqlprivilegespostgresql-9.2sql-grant

Permission denied for relation in PostgreSQL

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"

Does anyone have any idea what can be wrong?

Solution

  • 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.