Re: BUG #6768: Failure in OBDC

Sorry, all right. It was my mistake.

2012/7/27 Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>

> On 07/27/2012 07:52 AM, fabio(dot)lunkes(at)gmail(dot)com wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 6768
> Logged by: Fábio Hentz Lunkes
> Email address: fabio(dot)lunkes(at)gmail(dot)com
> PostgreSQL version: 9.1.0
> Operating system: Windows 7
> Description:
>
> Hellow.
> My teste to developer application with Microssoft Access, ODBC and Postgres.
> With grant selet in one field, other fields is revoke permissions, access in
> table with Microsoft Access is not possible. Failure is generate, to
> permission denied. In Microsoft MS Query, no error.
>
>
> I think you'll need to explain this in a bit more detail, with:
>
> - Table definitions
> - The EXACT commands you ran
> - The EXACT error messages
>
> As far as I know, running:
>
> GRANT SELECT on tablename(column) TO user;
>
> shouldn't in any way restrict their existing rights, and the documentation
> backs that up:
>
> http://www.postgresql.org/docs/9.1/static/sql-grant.html
>
> A user may perform SELECT, INSERT, etc. on a column if he holds that
> privilege for either the specific column or its whole table. Granting the
> privilege at the table level and then revoking it for one column will not
> do what you might wish: the table-level grant is unaffected by a
> column-level operation.
>
> ... so I think you might need to show what's happening in a bit more
> detail.
>
> Beware that there isn't a big Microsoft Access community here.
>
> --
> Craig Ringer
>

--
Att. Fábio Hentz Lunkes
Cientista da Computação

Celular: 54 9178 2435
Telefone: 54 3701 2435