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
Attachment:
signature.asc
Description: OpenPGP digital signature
