Ignoring the limited user-rights by using ODBC

Поиск
Список
Период
Сортировка
От Goeke, Tobias
Тема Ignoring the limited user-rights by using ODBC
Дата
Msg-id 72F45784D0E25A429B21E156EAEFE5E3E54BD3@muenchen.ep.de
обсуждение исходный текст
Ответы Re: Ignoring the limited user-rights by using ODBC  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Ignoring the limited user-rights by using ODBC  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Marko Ristola
Дата:
Сообщение: Transactions and savepoints
Следующее
От: BETTON Nicolas
Дата:
Сообщение: Installing PsqlODBC 8.00.0.1001 with libiodbc3-52.2 on Linux Fedora Core 1