create roles as normal user
От
Johannes
Тема
create roles as normal user
Дата
Msg-id
2dc1d081-01c8-646f-e931-b3ad07ea13e8@posteo.de
Список
Дерево обсуждения
create roles as normal user Johannes <jotpe@posteo.de>
Re: create roles as normal user Pavel Stehule <pavel.stehule@gmail.com>
Hello, I want a "normal" user to create roles inside the database. Is it only possible through the createrole privilige, or is there something like sudo possibile. I thought it is possible with the security definer option in create function, but that does not work for me: (In this test the function was created as superuser). ```sql CREATE OR REPLACE FUNCTION add_db1_user() returns void language sql STRICT security definer AS $$ CREATE ROLE db1_testuser login password 'secret'; $$ ERROR: permission denied to create role Best regards Johannes
В списке pgsql-general по дате отправления
От: Pavel Stehule
Дата: