Ignoring the limited user-rights by using ODBC

From: "Goeke, Tobias" <TGoeke(at)ElectronicPartner(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Ignoring the limited user-rights by using ODBC
Date: 2005-03-24 14:12:01
Message-ID: 72F45784D0E25A429B21E156EAEFE5E3E54BD3@muenchen.ep.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Jeff Eckermann 2005-03-24 15:10:29 Re: MS Access as front-end, migration from MSDE to POstgreSQL?
Previous Message BETTON Nicolas 2005-03-22 11:31:09 Installing PsqlODBC 8.00.0.1001 with libiodbc3-52.2 on Linux Fedora Core 1