Re: revoke select right on pg_proc

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: revoke select right on pg_proc
Дата
Msg-id 4BD6ED01.1000203@lelarge.info
обсуждение исходный текст
Ответ на Re: revoke select right on pg_proc  (Quan Zongliang <quanzongliang@gmail.com>)
Список pgadmin-support
Le 27/04/2010 15:50, Quan Zongliang a écrit :
> in fact, that guy should not list anything in pgAdmin?
> he said he can list views. it is weird.
> 
> in my test, i can select data in psql from tables that select right
> has been granted. but I can't list and object in pgAdmin.
> 

You can surely do \d in psql but you won't be able to do \d tablename.
In the first one, psql doesn't need to check triggers, but it needs to
do so in the second one (or at least, I suppose so).

That's also why you can't have the list of tables in pgAdmin. The query
pgAdmin fires tries to get informations on triggers in pg_proc. It fails
because of lack of permission.

That guy should use pgAdmin with a superuser, not a user with limited
rights. (I hope this limit will be over on 1.14, but it's still there
even in 1.12)


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com


В списке pgadmin-support по дате отправления:

Предыдущее
От: Quan Zongliang
Дата:
Сообщение: Re: revoke select right on pg_proc
Следующее
От: Barry Schatz
Дата:
Сообщение: pgAgent and pgpass