Re: MS Access and field-level permissions? - Mailing list pgsql-odbc

* 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