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
Re: Ignoring the limited user-rights by using ODBC
Список 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 по дате отправления: