Access SQL Passthrough queries should accomplish this.
>-----Original Message-----
>From: pgsql-odbc-owner@postgresql.org
>[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Stephen Frost
>Sent: Tuesday, August 17, 2010 4:04 PM
>To: Benjamin Smith
>Cc: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] MS Access and field-level permissions?
>
>
>* Benjamin Smith (lists@benjamindsmith.com) wrote:
>> This may be a PG issue and not an ODBC issue, but Filemaker
>Pro works
>> fine with
>> the restrictive permissions, MS Access is where things break.
>
>It's actually a SQL spec requirement..
>
>> ideas?
>
>You should be able to create queries in access against just
>the fields the user(s) have access to against the linked table
>(I'd hope anyway, but I'm not an Access expert). An
>alternative would be to create views that only pull through
>the columns you want visible to your Access users.
>
> Thanks,
>
> Stephen
>
