SET SESSION AUTHORIZATION superuser limitation.
| От | Dmitry Igrishin |
|---|---|
| Тема | SET SESSION AUTHORIZATION superuser limitation. |
| Дата | |
| Msg-id | CAAfz9KO_HBqXZbH90Q5=v+nEsmSBYDDPH0YLnKDHB2pR3LN3iA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: SET SESSION AUTHORIZATION superuser limitation.
|
| Список | pgsql-hackers |
Hackers,
--
There are feature which may be useful in conjunction with connection pools.
It is the ability to change the session user without creating the new
connection, like this:
(pseudo REPL):
notsuperuser > SELECT current_user, session_user;
notsuperuser notsuperuser
notsuperuser > SET SESSION AUTHORIZATION notsuperuser2 PASSWORD 'password_of_notsuperuser2';
SET SESSION AUTHORIZATION
notsuperuser2 > SELECT current_user, session_user;
notsuperuser2 notsuperuser2
notsuperuser2 > SET ROLE user3;
notsuperuser2 > SELECT current_user, session_user;
user3 notsuperuser2
According to [1], SET SESSION AUTHORIZATION can only be
used by superusers. Is it possible to extend it for use by not only
superusers?
// Dmitry.
В списке pgsql-hackers по дате отправления: