Re: Default permissions of system catalogs

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Default permissions of system catalogs
Дата
Msg-id 200201081858.g08Iw6912221@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Default permissions of system catalogs  (Dave Page <dpage@vale-housing.co.uk>)
Список pgsql-hackers
> > Objections?
> 
> I assume you are proposing the same privileges that you describe for a user
> table (i.e. by default only the owner (==superuser) has any access)?
> 
> If so, this would break pgAdmin for any users who are not the superuser on
> their system as the majority of it's operation relies on examining the
> system catalogues. In this case I would *strongly* object.
> 
> <thinks...> Surely this would also be the case for psql though - have I
> misunderstood something?

I assumed he was saying that the contents of pg_class permissions should
be interpreted the same whether it is a system table or not.  He would
set the proper system table permissions so they are visible to all users
like it is now.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: "Ulrich Neumann"
Дата:
Сообщение: Antw: Re: GETTIMEOFDAY_1ARG change
Следующее
От: Barry Lind
Дата:
Сообщение: Re: JDBC: why is PGobject class instead of interface?