Re: Ignoring the limited user-rights by using ODBC - Mailing list pgsql-odbc

From Peter Eisentraut
Subject Re: Ignoring the limited user-rights by using ODBC
Date
Msg-id 200503302014.20728.peter_e@gmx.net
Whole thread Raw
In response to Ignoring the limited user-rights by using ODBC  ("Goeke, Tobias" <TGoeke@ElectronicPartner.de>)
Responses Re: Ignoring the limited user-rights by using ODBC
List pgsql-odbc
Goeke, Tobias wrote:
> If i connect to the database via obdc with this user, all schemes are
> shown. So i am able to select all the tables and views e.g. in excel,
> although the user isn't autorized.

It is not possible that the ODBC driver can circumvent privileges that
would otherwise apply.  Please provide a detailed way to reproduce your
problem.

Note that what the \d commands in psql show does not necessarily define
the scope of a user's access privileges.  It merely shows what might be
of interest to the user.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-odbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Transactions and savepoints
Next
From: Peter Eisentraut
Date:
Subject: Re: Installing PsqlODBC 8.00.0.1001 with libiodbc3-52.2 on Linux Fedora Core 1