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