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