Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

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?




pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group