Skip site navigation (1) Skip section navigation (2)

MS Access and field-level permissions?

From: Benjamin Smith <lists(at)benjamindsmith(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: MS Access and field-level permissions?
Date: 2010-08-17 22:50:03
Message-ID: 201008171550.03057.lists@benjamindsmith.com (view raw or flat)
Thread:
Lists: 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.


Responses

pgsql-odbc by date

Next:From: Stephen FrostDate: 2010-08-17 23:04:07
Subject: Re: MS Access and field-level permissions?
Previous:From: Benjamin SmithDate: 2010-08-17 22:33:55
Subject: Re: Connection limits and MS Access?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group