public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: [email protected]
Subject: Docs issue for CREATE SCHEMA ... AUTHORIZATION permissions
Date: Wed, 03 Oct 2012 23:14:48 -0400
Message-ID: <[email protected]> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Docs issue for CREATE SCHEMA ... AUTHORIZATION permissions
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox