Re: granted select works in psql but not via jdbc - Mailing list pgsql-jdbc

J. wrote:

> I'm trying to set up a system where users will be limited based on their access.  To do this I'm querying db_roles
andif an exception is thrown, they're not a db admin.  The problem is that I've done this: 
>
> grant select on pg_roles to db_mid_level_admin;
                  ^^^^^^^^^
Wouldn't it be db_roles?

--
  Euler Taveira de Oliveira
  http://www.timbira.com/