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

From Benjamin Smith
Subject MS Access and field-level permissions?
Date
Msg-id 201008171550.03057.lists@benjamindsmith.com
Whole thread Raw
Responses Re: MS Access and field-level permissions?  (Stephen Frost <sfrost@snowman.net>)
Re: MS Access and field-level permissions?  (Richard Broersma <richard.broersma@gmail.com>)
Re: MS Access and field-level permissions?  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-odbc
Ok, now I have another issue...

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.

Similarly, with this configuration, via psql when I run "select * from table"
where I don't have permissions to all fields in the table, I get a "Permission
denied" error rather than any content.

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.

ideas?

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


pgsql-odbc by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: Connection limits and MS Access?
Next
From: Stephen Frost
Date:
Subject: Re: MS Access and field-level permissions?