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