1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
<!-- manual page source format generated by PolyglotMan v3.0.4, -->
<!-- available via anonymous ftp from ftp.cs.berkeley.edu:/ucb/people/phelps/tcltk/rman.tar.Z -->
<HTML>
<HEAD>
<TITLE>"ALTER(USER") manual page</TITLE>
</HEAD>
<BODY>
<A HREF="sql.html">SQL Reference Contents</A>
<H2><A NAME="sect0" HREF="#toc0">NAME </A></H2>
alter user -- alter user account information within a PostgreSQL instance
<H2><A NAME="sect1" HREF="#toc1">SYNOPSIS </A></H2>
<B>alter user </B> username <BR>
<tt> </tt><tt> </tt><tt> </tt><tt> </tt>[<B>with password </B> password] <BR>
<tt> </tt><tt> </tt><tt> </tt><tt> </tt>[<B>createdb </B>
| <B>nocreatedb </B>] <BR>
<tt> </tt><tt> </tt><tt> </tt><tt> </tt>[<B>createuser </B> | <B>nocreateuser </B>] <BR>
<tt> </tt><tt> </tt><tt> </tt><tt> </tt>[<B>in group </B> group-1, ..., group-n]
<BR>
<tt> </tt><tt> </tt><tt> </tt><tt> </tt>[<B>valid until ' </B>abstime<B>' </B>] <BR>
<H2><A NAME="sect2" HREF="#toc2">DESCRIPTION </A></H2>
<B>alter user</B> is used to change the
attributes of a user's PostgreSQL account. For a detailed description of
each of the clause in the alter user statement, please see the <A HREF="create_user.l.html">create_user(l)</A>
manual page. Please note that it is not possible to alter a user's usesysid
via the alter user statement. Also, it is only possible for the postgres
user or any user with read and modify permissions on pg_user to alter
user passwords. <P>
If any of the clauses of the alter user statement are
omitted, the corresponding value in the pg_user relation is left unchanged.
<P>
This statement can be used to modify users created with <A HREF="createuser.1.html">createuser(1)</A>
.
<P>
<H2><A NAME="sect3" HREF="#toc3">EXAMPLES </A></H2>
--- <BR>
--- Change a user password <BR>
--- <BR>
alter user tab with password hu8jmn3;
<BR>
--- <BR>
--- Change a user's valid until date <BR>
--- <BR>
alter user tab valid until 'Jan
31 2030'; <BR>
--- <BR>
--- Give a user the ability to create other users. <BR>
--- <BR>
alter user
tab createuser; <BR>
<H2><A NAME="sect4" HREF="#toc4">SEE ALSO </A></H2>
<A HREF="create_user.l.html">create_user(l)</A>
, <A HREF="drop_user.l.html">drop_user(l)</A>
. <P>
<HR><P>
<A NAME="toc"><B>Table of Contents</B></A><P>
<UL>
<LI><A NAME="toc0" HREF="#sect0">NAME</A></LI>
<LI><A NAME="toc1" HREF="#sect1">SYNOPSIS</A></LI>
<LI><A NAME="toc2" HREF="#sect2">DESCRIPTION</A></LI>
<LI><A NAME="toc3" HREF="#sect3">EXAMPLES</A></LI>
<LI><A NAME="toc4" HREF="#sect4">SEE ALSO</A></LI>
</UL>
</BODY></HTML>
|
