pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedGeneral Feedback
3+ messages / 3 participants
[nested] [flat]
* General Feedback
@ 2023-08-27 23:44 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2023-08-27 23:44 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: edwin.uy@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/sql-createschema.html
Description:
"To create a schema, the invoking user must have the CREATE privilege for
the current database. (Of course, superusers bypass this check.)" - maybe
you can show how to check if the user has the CREATE privilege? Or is this
omitted on purpose so readers will take their own initiative to find that
out themselves :-)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: General Feedback
@ 2023-08-28 14:38 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2023-08-28 14:38 UTC (permalink / raw)
To: edwin.uy@gmail.com; pgsql-docs@lists.postgresql.org
On Mon, Aug 28, 2023 at 7:33 AM PG Doc comments form <noreply@postgresql.org>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/15/sql-createschema.html
> Description:
>
> "To create a schema, the invoking user must have the CREATE privilege for
> the current database. (Of course, superusers bypass this check.)" - maybe
> you can show how to check if the user has the CREATE privilege? Or is this
> omitted on purpose so readers will take their own initiative to find that
> out themselves :-)
>
In the interest of brevity it is assumed the reader is familiar with the
definitional chapter regarding privileges and can use the knowledge gained
there to perform such database inspection.
https://www.postgresql.org/docs/current/ddl-priv.html
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: General Feedback
@ 2023-08-29 00:09 Edwin UY <edwin.uy@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Edwin UY @ 2023-08-29 00:09 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org
On Tue, Aug 29, 2023 at 2:38 AM David G. Johnston <
david.g.johnston@gmail.com> wrote:
> On Mon, Aug 28, 2023 at 7:33 AM PG Doc comments form <
> noreply@postgresql.org> wrote:
>
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/docs/15/sql-createschema.html
>> Description:
>>
>> "To create a schema, the invoking user must have the CREATE privilege for
>> the current database. (Of course, superusers bypass this check.)" - maybe
>> you can show how to check if the user has the CREATE privilege? Or is this
>> omitted on purpose so readers will take their own initiative to find that
>> out themselves :-)
>>
>
> In the interest of brevity it is assumed the reader is familiar with the
> definitional chapter regarding privileges and can use the knowledge gained
> there to perform such database inspection.
>
> https://www.postgresql.org/docs/current/ddl-priv.html
>
> David J.
>
>
Thanks for the reply. I assume that was the case.
I thought it has to do with specific CREATE privilege.
The user in question has the Create role only when I did a \du+.
I thought that would not allow him to do a CREATE SCHEMA but it did. So I
am guessing so long as the user has the CREATE, it is allowed to do the
CREATE SCHEMA.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-08-29 00:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-27 23:44 General Feedback PG Doc comments form <noreply@postgresql.org>
2023-08-28 14:38 ` David G. Johnston <david.g.johnston@gmail.com>
2023-08-29 00:09 ` Edwin UY <edwin.uy@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox