Docs issue for CREATE SCHEMA ... AUTHORIZATION permissions
Docs issue for CREATE SCHEMA ... AUTHORIZATION permissions
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
The CREATE SCHEMA reference page says "Only superusers can create schemas owned by users other than themselves". ISTM this is incorrect, or at least not the whole truth, because the test that is actually in the code is check_is_member_of_role(), that is whether the current user is allowed to SET ROLE to the target. In the SET ROLE reference page we say "The specified role_name must be a role that the current session user is a member of. (If the session user is a superuser, any role can be selected.)" Is that good wording to use in CREATE SCHEMA too, or would somebody like to wordsmith it? regards, tom lane