postgresql: permission denied for relation

Henry

I'm building a project using postgresql and java (NetBeans).

When I try to execute a simple query (select * from costumer) I get an error, telling me that "permission denied for relation costumer".

When I searched for an answer, all I found was about granting user privileges, so I went into pgAdmin and wrote "grant all privileges on database dirty to henrik;" . That didn't change anything - and that's why I'm making a new post..

The complete error message output of the program:

run:
1
2
3

Mar 23, 2014 7:47:18 PM sletdendog.SletDenDog main
SEVERE: ERROR: permission denied for relation costumer
org.postgresql.util.PSQLException: ERROR: permission denied for relation costumer
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
at sletdendog.SletDenDog.main(SletDenDog.java:27)

BUILD SUCCESSFUL (total time: 0 seconds)

The java program is really simple - it looks like this:

package sletdendog;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

public class SletDenDog {

private static Connection connection = null;
private static PreparedStatement statement = null;
private static ResultSet result = null;
private static ResultSetMetaData meta = null;

public static void main(String[] args) {

    try{
        System.out.println("1");
        connection = DriverManager.getConnection("jdbc:postgresql://localhost/dirty", "henrik", "hokus pokus");
        System.out.println("2");
        statement = connection.prepareStatement("select * from costumer;");
        System.out.println("3");
        result = statement.executeQuery();
        System.out.println("4");
        meta = result.getMetaData();
        System.out.println("5");
        for (int i = 1; i <= meta.getColumnCount(); i++) {
            System.out.println(meta.getColumnName(i));
        }

    } catch (SQLException ex){
        Logger lgr = Logger.getLogger(SletDenDog.class.getName());
        lgr.log(Level.SEVERE, ex.getMessage(), ex);
    } finally {
        try{
            if(connection != null){
                connection.close();
            }
            if(statement != null){
                statement.close();
            }
            if(result != null){
                result.close();
            }
        } catch(SQLException ex){

            System.out.println("Something wasn't closed...");

        }
    }   
}   
}
Erwin Brandstetter

Privileges on the database are not enough.
You also need at least the USAGE privilege for relevant schema and the SELECT privilege for the table.

More details in this closely related answer:
How to grant all privileges on views to arbitrary user

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

Permission denied for relation

From Dev

Permission denied on schema in PostgreSQL

From Dev

Permission denied on schema in PostgreSQL

From Dev

Django loaddata returns a permission denied for relation

From Dev

permission denied for relation django_migrations

From Dev

Rails: permission denied for relation schema_migrations

From Dev

Django loaddata returns a permission denied for relation

From Dev

PostgreSQL Error 42501: Permission Denied for Schema

From Dev

Shared memory in chroot environment for postgresql: permission denied?

From Dev

Permission Denied on shared object (.so) file postgresql

From Dev

PG::InsufficientPrivilege at / ERROR: permission denied for relation schema_migrations

From Dev

Rails: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations

From Dev

postgres database : Insufficient privilege, permission denied for relation table

From Dev

Rails: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations

From Dev

Permission Denied

From Dev

ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations

From Dev

Steps to Troubleshoot "django.db.utils.ProgrammingError: permission denied for relation django_migrations"

From Dev

ERROR: permission denied for relation after Heroku pg_dump and import to development database

From Dev

pg_dump: [archiver (db)] query failed: ERROR: permission denied for relation abouts

From Dev

Getting error while syncdb django.db.utils.ProgrammingError: permission denied for relation django_migrations

From Dev

Permission denied - missing INTERNET permission?

From Dev

Permission denied (missing INTERNET permission?): But permission is given

From Dev

Firebase write permission denied

From Dev

reading a file: permission denied

From Java

RMI Registry permission denied

From Java

gradlew: Permission Denied

From Dev

Permission denied in mac terminal

From Dev

permission denied pip virtualenv

From Java

Firebase Permission Denied

Related Related

  1. 1

    Permission denied for relation

  2. 2

    Permission denied on schema in PostgreSQL

  3. 3

    Permission denied on schema in PostgreSQL

  4. 4

    Django loaddata returns a permission denied for relation

  5. 5

    permission denied for relation django_migrations

  6. 6

    Rails: permission denied for relation schema_migrations

  7. 7

    Django loaddata returns a permission denied for relation

  8. 8

    PostgreSQL Error 42501: Permission Denied for Schema

  9. 9

    Shared memory in chroot environment for postgresql: permission denied?

  10. 10

    Permission Denied on shared object (.so) file postgresql

  11. 11

    PG::InsufficientPrivilege at / ERROR: permission denied for relation schema_migrations

  12. 12

    Rails: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations

  13. 13

    postgres database : Insufficient privilege, permission denied for relation table

  14. 14

    Rails: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations

  15. 15

    Permission Denied

  16. 16

    ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations

  17. 17

    Steps to Troubleshoot "django.db.utils.ProgrammingError: permission denied for relation django_migrations"

  18. 18

    ERROR: permission denied for relation after Heroku pg_dump and import to development database

  19. 19

    pg_dump: [archiver (db)] query failed: ERROR: permission denied for relation abouts

  20. 20

    Getting error while syncdb django.db.utils.ProgrammingError: permission denied for relation django_migrations

  21. 21

    Permission denied - missing INTERNET permission?

  22. 22

    Permission denied (missing INTERNET permission?): But permission is given

  23. 23

    Firebase write permission denied

  24. 24

    reading a file: permission denied

  25. 25

    RMI Registry permission denied

  26. 26

    gradlew: Permission Denied

  27. 27

    Permission denied in mac terminal

  28. 28

    permission denied pip virtualenv

  29. 29

    Firebase Permission Denied

HotTag

Archive