Re: MS Access and field-level permissions?

From: Stephen Frost <sfrost(at)snowman(dot)net>
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-17 23:04:07
Message-ID: 20100817230407.GA26232@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

* Benjamin Smith (lists(at)benjamindsmith(dot)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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Sufficool, Stanley 2010-08-17 23:19:51 Re: MS Access and field-level permissions?
Previous Message Benjamin Smith 2010-08-17 22:50:03 MS Access and field-level permissions?