ODBC Driver exposes tables and views that a user does not have permission to access.

Поиск
Список
Период
Сортировка
От Harris, Richard
Тема ODBC Driver exposes tables and views that a user does not have permission to access.
Дата
Msg-id E2F600719FA6FF438A680A22A00DA43C0696BC99@EXCHANGEDS01.ds.ad.adp.com
обсуждение исходный текст
Ответы Re: ODBC Driver exposes tables and views that a user does  (Shachar Shemesh <psql@shemesh.biz>)
Список pgsql-odbc
Hi,

PostgreSQL server 7.4.2
psqlODBC driver: 7.03.02.00

I created a database user in a postgresql cluster. I granted that user
SELECT permission to a few views. I created a DSN for that user to
connect to postgreSQL from a Windows PC. When I use the DSN in MS Access
to link to the views, the Link Tables list includes many tables and
views that the user has no permission to access. Is this a defect in the
ODBC driver? Is there a work around for this?

Thanks,
Rich Harris

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Brian J. Erickson"
Дата:
Сообщение: IM003 when using ODBC
Следующее
От: Shachar Shemesh
Дата:
Сообщение: Re: ODBC Driver exposes tables and views that a user does