Table (or Column?) level permissions - Mailing list pgsql-jdbc

From Jonathan Mast
Subject Table (or Column?) level permissions
Date
Msg-id 85e352e10801140937t6b9a3727gc62468126b3bd9f8@mail.gmail.com
Whole thread Raw
Responses Re: Table (or Column?) level permissions  (imad <immaad@gmail.com>)
List pgsql-jdbc
We have some JSP code that accesses a table.  The problem is that some fields will not return results when selected for, nor will they throw exceptions.

My question is: Can certain columns of a table be restricted in terms of who can access them?

The queries are of the form:

SELECT * FROM myTbl WHERE col_A="someValue";

col_A works, but col_B, col_C, etc. don't.

I'm echoing the queries on the webpage, and these queries will work when manually copied into the pgAdmin.

thanks,
jhmast

pgsql-jdbc by date:

Previous
From: Silvio Bierman
Date:
Subject: Re: Howto set UUID parameter for PGSQL 8.3rc1 / postgresql-8.3dev-602.jdbc3.jar
Next
From: Juergen Reif
Date:
Subject: Pl/Java broken since Postgresql 8.3-rc1