Re: OWNER TO on all objects

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: OWNER TO on all objects
Дата
Msg-id 21244.1087392391@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: OWNER TO on all objects  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> There is one other consideration, and that is that current pg_dump likes 
> to set session_auth to user of object before outputting drop command, 
> when '-c' is specificed.

> I propose that we eliminate that set session_auth as well.  If the user 
> running the script is the owner of that object or a superuser, then they 
> will be able to drop it.  If they are neither, then the drop will fail, 
> but the session_authorization would have failed anyway!

Seems reasonable.  The -c option is pretty badly thought out anyway :-(
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: OWNER TO on all objects
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Improving postgresql.conf