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

From Goeke, Tobias
Subject Ignoring the limited user-rights by using ODBC
Date
Msg-id 72F45784D0E25A429B21E156EAEFE5E3E54BD3@muenchen.ep.de
Whole thread Raw
Responses Re: Ignoring the limited user-rights by using ODBC
Re: Ignoring the limited user-rights by using ODBC
List pgsql-odbc
Hello,

I created a new user in a new schema.
This user is only authorized to select the views in this schema.
If i look at the tables and views for this user by using "\d", there are
only a few views shown.
That means that the rights are correctly set.

Now the real problem:

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.

I should only be able to select a few views, like it is configured in psql.
How can i constrain this?

Can you help me?

Thanks
    Tobias




pgsql-odbc by date:

Previous
From: Marko Ristola
Date:
Subject: Transactions and savepoints
Next
From: BETTON Nicolas
Date:
Subject: Installing PsqlODBC 8.00.0.1001 with libiodbc3-52.2 on Linux Fedora Core 1