Table (or Column?) level permissions

Поиск
Список
Период
Сортировка
От Jonathan Mast
Тема Table (or Column?) level permissions
Дата
Msg-id 85e352e10801140937t6b9a3727gc62468126b3bd9f8@mail.gmail.com
обсуждение исходный текст
Ответы Re: Table (or Column?) level permissions
Список 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 по дате отправления: