Re: Ignoring the limited user-rights by using 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/