Re: MS Access and field-level permissions?

On Tue, Aug 17, 2010 at 3:50 PM, Benjamin Smith
<lists@benjamindsmith.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.

I've never tried to setup field level permissions on access linked
tables before, so this is news to me.  However, I wonder if this
behavior is a result of the way MS-Access implements optimistic
locking.  I'll have to do more digging on this subject.


> 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 is correct.  This is the way it is documented to work since '*'
expands to list every field of the set.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug