Re: Why do i need to install set_user extension if i can directly grant all required privileges to user?

Поиск
Список
Период
Сортировка
От Holger Jakobs
Тема Re: Why do i need to install set_user extension if i can directly grant all required privileges to user?
Дата
Msg-id 44912597-d81a-aece-2222-5a2e116dc0e1@jakobs.com
обсуждение исходный текст
Ответ на Re: Why do i need to install set_user extension if i can directly grant all required privileges to user?  (Erik Wienhold <ewie@ewie.name>)
Ответы Re: Why do i need to install set_user extension if i can directly grant all required privileges to user?  (Bhasker Bathini <bbathini@gmail.com>)
Список pgsql-admin
Am 21.06.23 um 15:33 schrieb Erik Wienhold:

Changing roles is already possible in Postgres.  You must be a member of the
target role or be a superuser in order to change roles. 

This is going to change in detail as of version 16 of PostgreSQL. You may determine whether a role switch is allowed or not.

Excerpt from https://www.postgresql.org/docs/16/sql-grant.html:

"The SET option, if it is set to TRUE, allows the member to change to the granted role using the SET ROLE command. If a role is an indirect member of another role, it can use SET ROLE to change to that role only if there is a chain of grants each of which has SET TRUE. This option defaults to TRUE."



-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Вложения

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

Предыдущее
От: Sean O'Grady
Дата:
Сообщение: Re: Question about wal_compression and what to expect
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Question about wal_compression and what to expect