pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Improve documentation of the CREATEROLE attibute. 6+ messages / 1 participants [nested] [flat]
* pgsql: Improve documentation of the CREATEROLE attibute. @ 2023-01-03 20:09 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Robert Haas @ 2023-01-03 20:09 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Improve documentation of the CREATEROLE attibute. In user-manag.sgml, document precisely what privileges are conveyed by CREATEROLE. Make particular note of the fact that it allows changing passwords and granting access to high-privilege roles. Also remove the suggestion of using a user with CREATEROLE and CREATEDB instead of a superuser, as there is no real security advantage to this approach. Elsewhere in the documentation, adjust text that suggests that <literal>CREATEROLE</literal> only allows for role creation, and refer to the documentation in user-manag.sgml as appropriate. Patch by me, reviewed by Álvaro Herrera Discussion: http://postgr.es/m/CA+TgmoZBsPL8nPhvYecx7iGo5qpDRqa9k_AcaW1SbOjugAY1Ag@mail.gmail.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/5dac191edf1816860993e5f43b817eafcece1166 Modified Files -------------- doc/src/sgml/ref/alter_role.sgml | 2 +- doc/src/sgml/ref/create_role.sgml | 10 ++++----- doc/src/sgml/ref/createuser.sgml | 18 ++++++++++----- doc/src/sgml/user-manag.sgml | 47 +++++++++++++++++++++++++++------------ 4 files changed, 52 insertions(+), 25 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Improve documentation of the CREATEROLE attibute. @ 2023-01-03 20:09 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Robert Haas @ 2023-01-03 20:09 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Improve documentation of the CREATEROLE attibute. In user-manag.sgml, document precisely what privileges are conveyed by CREATEROLE. Make particular note of the fact that it allows changing passwords and granting access to high-privilege roles. Also remove the suggestion of using a user with CREATEROLE and CREATEDB instead of a superuser, as there is no real security advantage to this approach. Elsewhere in the documentation, adjust text that suggests that <literal>CREATEROLE</literal> only allows for role creation, and refer to the documentation in user-manag.sgml as appropriate. Patch by me, reviewed by Álvaro Herrera Discussion: http://postgr.es/m/CA+TgmoZBsPL8nPhvYecx7iGo5qpDRqa9k_AcaW1SbOjugAY1Ag@mail.gmail.com Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/5136c3fb575bb46f5f33c0485c972aa5dea0757a Modified Files -------------- doc/src/sgml/ref/alter_role.sgml | 2 +- doc/src/sgml/ref/create_role.sgml | 10 ++++----- doc/src/sgml/ref/createuser.sgml | 18 ++++++++++----- doc/src/sgml/user-manag.sgml | 47 +++++++++++++++++++++++++++------------ 4 files changed, 52 insertions(+), 25 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Improve documentation of the CREATEROLE attibute. @ 2023-01-03 20:09 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Robert Haas @ 2023-01-03 20:09 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Improve documentation of the CREATEROLE attibute. In user-manag.sgml, document precisely what privileges are conveyed by CREATEROLE. Make particular note of the fact that it allows changing passwords and granting access to high-privilege roles. Also remove the suggestion of using a user with CREATEROLE and CREATEDB instead of a superuser, as there is no real security advantage to this approach. Elsewhere in the documentation, adjust text that suggests that <literal>CREATEROLE</literal> only allows for role creation, and refer to the documentation in user-manag.sgml as appropriate. Patch by me, reviewed by Álvaro Herrera Discussion: http://postgr.es/m/CA+TgmoZBsPL8nPhvYecx7iGo5qpDRqa9k_AcaW1SbOjugAY1Ag@mail.gmail.com Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0b496bc9881fdcb3c20aeaa08bcdc196b8ec6946 Modified Files -------------- doc/src/sgml/ref/alter_role.sgml | 2 +- doc/src/sgml/ref/create_role.sgml | 10 ++++----- doc/src/sgml/ref/createuser.sgml | 18 ++++++++++----- doc/src/sgml/user-manag.sgml | 47 +++++++++++++++++++++++++++------------ 4 files changed, 52 insertions(+), 25 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Improve documentation of the CREATEROLE attibute. @ 2023-01-03 20:09 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Robert Haas @ 2023-01-03 20:09 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Improve documentation of the CREATEROLE attibute. In user-manag.sgml, document precisely what privileges are conveyed by CREATEROLE. Make particular note of the fact that it allows changing passwords and granting access to high-privilege roles. Also remove the suggestion of using a user with CREATEROLE and CREATEDB instead of a superuser, as there is no real security advantage to this approach. Elsewhere in the documentation, adjust text that suggests that <literal>CREATEROLE</literal> only allows for role creation, and refer to the documentation in user-manag.sgml as appropriate. Patch by me, reviewed by Álvaro Herrera Discussion: http://postgr.es/m/CA+TgmoZBsPL8nPhvYecx7iGo5qpDRqa9k_AcaW1SbOjugAY1Ag@mail.gmail.com Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/aa26980ca0813200c25b06e3ad0f54d449cce8b2 Modified Files -------------- doc/src/sgml/ref/alter_role.sgml | 2 +- doc/src/sgml/ref/create_role.sgml | 10 ++++----- doc/src/sgml/ref/createuser.sgml | 18 ++++++++++----- doc/src/sgml/user-manag.sgml | 47 +++++++++++++++++++++++++++------------ 4 files changed, 52 insertions(+), 25 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Improve documentation of the CREATEROLE attibute. @ 2023-01-03 20:09 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Robert Haas @ 2023-01-03 20:09 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Improve documentation of the CREATEROLE attibute. In user-manag.sgml, document precisely what privileges are conveyed by CREATEROLE. Make particular note of the fact that it allows changing passwords and granting access to high-privilege roles. Also remove the suggestion of using a user with CREATEROLE and CREATEDB instead of a superuser, as there is no real security advantage to this approach. Elsewhere in the documentation, adjust text that suggests that <literal>CREATEROLE</literal> only allows for role creation, and refer to the documentation in user-manag.sgml as appropriate. Patch by me, reviewed by Álvaro Herrera Discussion: http://postgr.es/m/CA+TgmoZBsPL8nPhvYecx7iGo5qpDRqa9k_AcaW1SbOjugAY1Ag@mail.gmail.com Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1a5ff7be26966cec33d5593b89f8c5f94d29d036 Modified Files -------------- doc/src/sgml/ref/alter_role.sgml | 2 +- doc/src/sgml/ref/create_role.sgml | 10 ++++----- doc/src/sgml/ref/createuser.sgml | 18 ++++++++++----- doc/src/sgml/user-manag.sgml | 47 +++++++++++++++++++++++++++------------ 4 files changed, 52 insertions(+), 25 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Improve documentation of the CREATEROLE attibute. @ 2023-01-03 20:09 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Robert Haas @ 2023-01-03 20:09 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Improve documentation of the CREATEROLE attibute. In user-manag.sgml, document precisely what privileges are conveyed by CREATEROLE. Make particular note of the fact that it allows changing passwords and granting access to high-privilege roles. Also remove the suggestion of using a user with CREATEROLE and CREATEDB instead of a superuser, as there is no real security advantage to this approach. Elsewhere in the documentation, adjust text that suggests that <literal>CREATEROLE</literal> only allows for role creation, and refer to the documentation in user-manag.sgml as appropriate. Patch by me, reviewed by Álvaro Herrera Discussion: http://postgr.es/m/CA+TgmoZBsPL8nPhvYecx7iGo5qpDRqa9k_AcaW1SbOjugAY1Ag@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/1c77873727dfd2e48ab2ece84d1fb1676e95f9a5 Modified Files -------------- doc/src/sgml/ref/alter_role.sgml | 2 +- doc/src/sgml/ref/create_role.sgml | 10 ++++----- doc/src/sgml/ref/createuser.sgml | 18 ++++++++++----- doc/src/sgml/user-manag.sgml | 47 +++++++++++++++++++++++++++------------ 4 files changed, 52 insertions(+), 25 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-01-03 20:09 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-01-03 20:09 pgsql: Improve documentation of the CREATEROLE attibute. Robert Haas <rhaas@postgresql.org> 2023-01-03 20:09 pgsql: Improve documentation of the CREATEROLE attibute. Robert Haas <rhaas@postgresql.org> 2023-01-03 20:09 pgsql: Improve documentation of the CREATEROLE attibute. Robert Haas <rhaas@postgresql.org> 2023-01-03 20:09 pgsql: Improve documentation of the CREATEROLE attibute. Robert Haas <rhaas@postgresql.org> 2023-01-03 20:09 pgsql: Improve documentation of the CREATEROLE attibute. Robert Haas <rhaas@postgresql.org> 2023-01-03 20:09 pgsql: Improve documentation of the CREATEROLE attibute. Robert Haas <rhaas@postgresql.org>
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