Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not the owner
Дата
Msg-id 87bm3u8fki.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Able to do ALTER DEFAULT PRIVILEGES from a user who is not theowner  (rajan <vgmonnet@gmail.com>)
Ответы Re: Able to do ALTER DEFAULT PRIVILEGES from a user who is not theowner
Список pgsql-hackers
>>>>> "rajan" == rajan  <vgmonnet@gmail.com> writes:

 rajan> --with the student user have no privilege how ALTER DEFAULT PRIVILEGES
 rajan> works????
 rajan> *learning=> ALTER DEFAULT PRIVILEGES IN SCHEMA additional GRANT INSERT ON
 rajan> TABLES TO student;

This ALTER only affects the default privileges for tables created by
the role "student" (because they're the ones executing the ALTER), it
does not affect default privileges for tables created by anybody else.

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: speeding up planning with partitions
Следующее
От: Andres Freund
Дата:
Сообщение: Re: fast defaults in heap_getattr vs heap_deform_tuple