Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Table (or Colum...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 1862 of 1998
Post > Topic >>

Table (or Column?) level permissions

by jonathan.h.mast@[EMAIL PROTECTED] ("Jonathan Mast") Jan 14, 2008 at 12:37 PM

------=_Part_11093_2135784.1200332245078
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_11093_2135784.1200332245078
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

We have some JSP code that accesses a table.&nbsp; The problem is that
some fields will not return results when selected for, nor will they throw
exceptions.<br><br>My question is: Can certain columns of a table be
restricted in terms of who can access them?
<br><br>The queries are of the form:<br><br>SELECT * FROM myTbl WHERE
col_A=&quot;someValue&quot;;<br><br>col_A works, but col_B, col_C, etc.
don&#39;t.<br><br>I&#39;m echoing the queries on the webpage, and these
queries will work when manually copied into the pgAdmin.
<br><br>thanks,<br>jhmast<br>

------=_Part_11093_2135784.1200332245078--
 




 2 Posts in Topic:
Table (or Column?) level permissions
jonathan.h.mast@[EMAIL PR  2008-01-14 12:37:25 
Re: Table (or Column?) level permissions
immaad@[EMAIL PROTECTED]   2008-01-15 01:52:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 13:28:41 CDT 2008.