aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/alter_user.sgml
Commit message (Collapse)AuthorAge
* Fix erroneous documentation about noise word GROUP.Tom Lane2017-09-20
| | | | | | | | | | | | | GRANT, REVOKE, and some allied commands allow the noise word GROUP before a role name (cf. grantee production in gram.y). This option does not exist elsewhere, but it had nonetheless snuck into the documentation for ALTER ROLE, ALTER USER, and CREATE SCHEMA. Seems to be a copy-and-pasteo in commit 31eae6028, which did expand the syntax choices here, but not in that way. Back-patch to 9.5 where that came in. Discussion: https://postgr.es/m/20170916123750.8885.66941@wrigleys.postgresql.org
* Add missing ALTER USER variantsPeter Eisentraut2017-08-03
| | | | | | | ALTER USER ... SET did not support all the syntax variants of ALTER ROLE ... SET. Reported-by: Pavel Golub <pavel@microolap.com>
* Add [NO]BYPASSRLS options to CREATE USER and ALTER USER docs.Robert Haas2016-01-28
| | | | | | Patch-by: Filip Rembiałkowski Reviewed-by: Robert Haas Backpatch-through: 9.5
* Allow CURRENT/SESSION_USER to be used in certain commandsAlvaro Herrera2015-03-09
| | | | | | | | | | | | | | | | | | | | | Commands such as ALTER USER, ALTER GROUP, ALTER ROLE, GRANT, and the various ALTER OBJECT / OWNER TO, as well as ad-hoc clauses related to roles such as the AUTHORIZATION clause of CREATE SCHEMA, the FOR clause of CREATE USER MAPPING, and the FOR ROLE clause of ALTER DEFAULT PRIVILEGES can now take the keywords CURRENT_USER and SESSION_USER as user specifiers in place of an explicit user name. This commit also fixes some quite ugly handling of special standards- mandated syntax in CREATE USER MAPPING, which in particular would fail to work in presence of a role named "current_user". The special role specifiers PUBLIC and NONE also have more consistent handling now. Also take the opportunity to add location tracking to user specifiers. Authors: Kyotaro Horiguchi. Heavily reworked by Álvaro Herrera. Reviewed by: Rushabh Lathia, Adam Brightwell, Marti Raudsepp.
* doc: Improve DocBook XML validityPeter Eisentraut2014-02-23
| | | | | | | | | | | DocBook XML is superficially compatible with DocBook SGML but has a slightly stricter DTD that we have been violating in a few cases. Although XSLT doesn't care whether the document is valid, the style sheets don't necessarily process invalid documents correctly, so we need to work toward fixing this. This first commit moves the indexterms in refentry elements to an allowed position. It has no impact on the output.
* Add REPLICATION privilege for ROLEsMagnus Hagander2010-12-29
| | | | | | | | | | | This privilege is required to do Streaming Replication, instead of superuser, making it possible to set up a SR slave that doesn't have write permissions on the master. Superuser privileges do NOT override this check, so in order to use the default superuser account for replication it must be explicitly granted the REPLICATION permissions. This is backwards incompatible change, in the interest of higher default security.
* Remove useless whitespace at end of linesPeter Eisentraut2010-11-23
|
* Remove cvs keywords from all files.Magnus Hagander2010-09-20
|
* Remove unnecessary xref endterm attributes and title idsPeter Eisentraut2010-04-03
| | | | | | | | | The endterm attribute is mainly useful when the toolchain does not support automatic link target text generation for a particular situation. In the past, this was required by the man page tools for all reference page links, but that is no longer the case, and it now actually gets in the way of proper automatic link text generation. The only remaining use cases are currently xrefs to refsects.
* Make the placeholder naming in the synopses of the SQL help more consistentPeter Eisentraut2009-09-19
|
* Easier to translate psql helpPeter Eisentraut2009-09-18
| | | | | | | | | | | Instead of requiring translators to translate the entire SQL command synopses, change create_help.pl to only require them to translate the placeholders, and paste those into the synopsis using a printf mechanism. Make some small updates to the markup to make it easier to parse. Note: This causes msgmerge of gettext 0.17 to segfault. You will need the patch from https://savannah.gnu.org/bugs/?27474 to make it work. msgmerge usually only runs on babel.postgresql.org, however.
* Set SQL man pages to be section 7 by default, and only transform them toPeter Eisentraut2008-11-14
| | | | | | | | | another section if required by the platform (instead of the old way of building them in section "l" and always transforming them to the platform-specific section). This speeds up the installation on common platforms, and it avoids some funny business with the man page tools and build process.
* Support SET FROM CURRENT in CREATE/ALTER FUNCTION, ALTER DATABASE, ALTER ROLE.Tom Lane2007-09-03
| | | | | | | (Actually, it works as a plain statement too, but I didn't document that because it seems a bit useless.) Unify VariableResetStmt with VariableSetStmt, and clean up some ancient cruft in the representation of same.
* Fix a bunch of bad grammar in the docs: "<link>, which see for moreNeil Conway2007-05-15
| | | | information" is un-good English.
* Remove emacs info from footer of SGML files.Bruce Momjian2006-09-16
|
* Call SET varaiables "configuration_parameter"s in the documentation.Bruce Momjian2006-04-25
|
* Change "parameter" to "varname" in the alter role and alter userBruce Momjian2006-04-25
| | | | | | documentation sections. Also update SET/RESET to be consistent. Nicolas Barbier
* Add per-user and per-database connection limit options.Tom Lane2005-07-31
| | | | | This patch also includes preliminary update of pg_dumpall for roles. Petr Jelinek, with review by Bruce Momjian and Tom Lane.
* Basic documentation for ROLEs. The user-manag chapter still needs toTom Lane2005-07-26
| | | | be rewritten, but at least the reference pages are reasonably sane.
* Re-readjust synopses for CREATE/ALTER USER.Tom Lane2005-01-06
|
* Revert cosmetic synopsis changes that break psql translations.Peter Eisentraut2005-01-05
|
* More minor updates and copy-editing.Tom Lane2005-01-04
|
* Spell checker runPeter Eisentraut2004-12-13
|
* Erase MD5 user passwords when a user is renamed because the username isBruce Momjian2004-05-06
| | | | used as salt for the MD5 password.
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-29
|
* Make the SQL command synopses appear less random.Peter Eisentraut2003-09-22
|
* Remove a bunch of content-free Diagnostics sections, as per previousTom Lane2003-09-09
| | | | discussion. (Still have some work to do editing the remainder.)
* Add/edit index entries.Peter Eisentraut2003-08-31
|
* First batch of object rename commands.Peter Eisentraut2003-06-27
|
* Bring SQL ref pages to consistent format, part 1.Peter Eisentraut2003-04-15
|
* Merge documentation into one book. (Build with "make html".) ReplacePeter Eisentraut2003-03-25
| | | | vague cross-references with real links.
* This is not the only place in the system catalogs where NULL isBruce Momjian2003-03-20
| | | | | | | | | | | | | | | | | effectively used to mean a default value that could also be spelled out explicitly. (ACLs behave that way, and useconfig/datconfig do too IIRC.) It's a bit of a hack, but it saves table space and backend code --- without this convention the default would have to be inserted "manually" since we have no mechanism to supply defaults when C code is forming a new catalog tuple. I'm inclined to leave the code alone. But Alvaro is right that it'd be good to point out the 'infinity' option in the CREATE USER and ALTER USER man pages. (Doc patch please?) Alvaro Herrera
* This patch includes a lot of minor cleanups to the SGML documentation,Bruce Momjian2003-01-19
| | | | | | | | | | | | | | | | | | including: - replacing all the appropriate usages of <citetitle>PostgreSQL ...</citetitle> with &cite-user;, &cite-admin;, and so on - fix an omission in the EXECUTE documentation - add some more text to the EXPLAIN documentation - improve the PL/PgSQL RETURN NEXT documentation (more work to do here) - minor markup fixes Neil Conway
* Add more appropriate markup.Peter Eisentraut2002-09-21
|
* Merge the last few variable.c configuration variables into the genericTom Lane2002-05-17
| | | | | | | | | GUC support. It's now possible to set datestyle, timezone, and client_encoding from postgresql.conf and per-database or per-user settings. Also, implement rollback of SET commands that occur in a transaction that later fails. Create a SET LOCAL var = value syntax that sets the variable only for the duration of the current transaction. All per previous discussions in pghackers.
* Spell checking and markup additionsPeter Eisentraut2002-03-22
|
* User and database-specific session defaults for run-time configurationPeter Eisentraut2002-03-01
| | | | variables. New commands ALTER DATABASE ... SET and ALTER USER ... SET.
* Some cleanups in CREATE/ALTER/DROP USER ref pages.Peter Eisentraut2002-02-27
|
* Use PostgreSQL consistantly throughout docs. Before, usage was split evenlyThomas G. Lockhart2001-12-08
| | | | between Postgres and PostgreSQL.
* Code review for MD5 authorization patch. Clean up some breakageTom Lane2001-09-21
| | | | (salts were always zero!?), add much missing documentation.
* Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut2001-09-03
|
* Use MD5 for wire protocol encryption for >= 7.2 client/server.Bruce Momjian2001-08-15
| | | | | | | Allow pg_shadow to be MD5 encrypted. Add ENCRYPTED/UNENCRYPTED option to CREATE/ALTER user. Add password_encryption postgresql.conf option. Update wire protocol version to 2.1.
* Changes from Vince Vielhaber to allow the optional clauses of CREATETom Lane2001-07-10
| | | | | | | | USER and ALTER USER to appear in any order, not only the fixed order they used to be required to appear in. Also, some changes from Tom Lane to create a FULL option for VACUUM; it doesn't do anything yet, but I needed to change many of the same files to make that happen, so now seemed like a good time.
* spell cleanupsBruce Momjian2000-07-22
|
* CleanupsBruce Momjian2000-07-22
|
* Start updating for the v7.0 release.Thomas G. Lockhart2000-03-27
| | | | | Use "generic functions" for math and other routines. Use SQL92 "type 'literal'" syntax rather than Postgres "'literal'::type".
* * User management commands no longer user pg_exec_query_dest -> more robustPeter Eisentraut2000-01-14
| | | | | | | | | | | | * Let unprivileged users change their own passwords. * The password is now an Sconst in the parser, which better reflects its text datatype and also forces users to quote them. * If your password is NULL you won't be written to the password file, meaning you can't connect until you have a password set up (if you use password authentication). * When you drop a user that owns a database you get an error. The database is not gone.
* create/alter user extensionBruce Momjian1999-11-30
| | | | | | | | | This one should work much better than the one I sent in previously. The functionality is the same, but the patch was missing one file resulting in the compilation failing. The docs also received a minor fix. Peter Eisentraut Sernanders väg 10:115
* Complete merge of all old man page information.Thomas G. Lockhart1999-07-22
| | | | ecpg reference page still needs formatting.
* Fix markup for docbook2man man page generation.Thomas G. Lockhart1999-07-06
| | | | | | | No big deal; fixed lots of other markup at the same time. Bigest change: make sure there is no whitespace in front of <term> contents. This will probably help the other output types too.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-15 02:03:54 +0000