pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Document PUBLIC grants on PUBLIC schema 2+ messages / 2 participants [nested] [flat]
* Document PUBLIC grants on PUBLIC schema @ 2017-09-30 14:18 buck@dbrhino.com 0 siblings, 1 reply; 2+ messages in thread From: buck@dbrhino.com @ 2017-09-30 14:18 UTC (permalink / raw) To: pgsql-docs The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/sql-grant.html Description: The GRANT documentation, regarding the PUBLIC role, says: > No privileges are granted to PUBLIC by default on tables, columns, schemas or tablespaces. But the PUBLIC role does receive USAGE and CREATE privileges on the PUBLIC schema, correct? I think the documentation should point this out. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Document PUBLIC grants on PUBLIC schema @ 2017-10-03 15:12 Tom Lane <tgl@sss.pgh.pa.us> parent: buck@dbrhino.com 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2017-10-03 15:12 UTC (permalink / raw) To: buck@dbrhino.com; +Cc: pgsql-docs buck@dbrhino.com writes: > The GRANT documentation, regarding the PUBLIC role, says: > > No privileges are granted to PUBLIC by default on tables, columns, schemas > or tablespaces. > But the PUBLIC role does receive USAGE and CREATE privileges on the PUBLIC > schema, correct? I think the documentation should point this out. The GRANT page is meant to explain what happens when you create new objects. It does not attempt to explain the privileges attached to every predefined object, and that seems like a rather impractical thing to do there. We tend to document nondefault privileges for built-in objects where those objects are described. In the case of the public schema, it's described here: https://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PUBLIC but since privileges for schemas haven't been mentioned at that point, the issue is taken up a little further down: https://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PRIV regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-10-03 15:12 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-09-30 14:18 Document PUBLIC grants on PUBLIC schema buck@dbrhino.com 2017-10-03 15:12 ` Tom Lane <tgl@sss.pgh.pa.us>
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