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.