Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group