On Tue, Aug 17, 2010 at 3:50 PM, Benjamin Smith
> 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.
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
In response to
pgsql-odbc by date
|Next:||From: Gustavo Pinsard||Date: 2010-08-18 18:37:42|
|Subject: Silent install - check "I accept the terms..."|
|Previous:||From: Albin Blaschka||Date: 2010-08-18 06:29:54|
|Subject: Re: OpenOffice, Go-OO, ODBC, Offline Data Entry|