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
Дата:
От: Pavel Stehule
Дата:
FAQ