Re: MS Access and field-level permissions?

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Benjamin Smith <lists(at)benjamindsmith(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MS Access and field-level permissions?
Date: 2010-08-18 22:23:42
Message-ID: AANLkTina02iczO-qxrpOWaHgA4nk8E46kukjf4Di0UhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Tue, Aug 17, 2010 at 3:50 PM, Benjamin Smith
<lists(at)benjamindsmith(dot)com> wrote:

> We're using field level permissions to restrict what data is accessible over
> ODBC - we're enabling SELECT only and on a restrictive set of fields. But, when
> we try to link up with MS Access, none of the fields are populated. You can see
> the fields, but never the content of the fields.

If you have select rights on every field in the table, it should
display provided you also grant select on xmin which the odbc driver
is also calling if you've configured it that way.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Benjamin Smith 2010-08-18 23:19:21 Re: MS Access and field-level permissions?
Previous Message Gustavo Pinsard 2010-08-18 18:37:42 Silent install - check "I accept the terms..."