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

From: "Harris, Richard" <Richard_Harris(at)adp(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC Driver exposes tables and views that a user does not have permission to access.
Date: 2005-05-26 19:39:32
Message-ID: E2F600719FA6FF438A680A22A00DA43C0696BC99@EXCHANGEDS01.ds.ad.adp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message ￥９８００ねっと 2005-05-26 19:50:38 L@VDVDIwV[YxDVDI
Previous Message MoOoOoOoOdY 505 2005-05-26 12:38:01 CrAz88Girz