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/