Hi,
On v 12.0.4-18, I am creating schema from account with pseudosuperuser:
create schema myschema authorization myschema_owner default include privileges;
myschema_owner account already exist.
Getting error Unsufficient privileges.
I has to break this into two statements:
create schema myschema default include privileges;
alter schema myschema owner to myschema_owner;
That works fine under account with pseudosuperuser.
Apparently, combined statement runs properly only from dbadmin:
create schema myschema authorization myschema_owner default include privileges;
I am not sure if this is intended behaviour - why pseudosuperuser cannot set schema authorization?
Please ask security team.
Thank you
Sergey