Postgres Pro
Downloads
Home   >   mailing lists

Database privileges - Mailing list pgsql-novice

From Diogo Martinez
Subject Database privileges
Date
Msg-id CABiZpKyyYjnqtjmbEagFRXi068VN0eMbGgMHvbXT5tCXU1MySw@mail.gmail.com
Whole thread Raw
Responses Re: Database privileges  ("Day, David" <dday@redcom.com>)
Re: Database privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
Hi,

I've installed PostgreSQL 9.2.4, created a new database, created 1 new role and 1 table called t_test.
When I connect using psql with my new role and do a simple query (select * from t_test), it works fine, but when I connect using JDBC using the same role, I get a no privileges exception.

Can anybody help me, please?

Thanks,
Diogo

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: PostgreSQL version upgrade (9.1 to 9.2)
Next
From: kobolds
Date:
Subject: create database with owner