2
.\" Title: ALTER USER MAPPING
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "ALTER USER MAPPING" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
ALTER_USER_MAPPING \- change the definition of a user mapping
23
.\" ALTER USER MAPPING
27
ALTER USER MAPPING FOR { \fIuser_name\fR | USER | CURRENT_USER | PUBLIC }
28
SERVER \fIserver_name\fR
29
OPTIONS ( [ ADD | SET | DROP ] \fIoption\fR [\(aq\fIvalue\fR\(aq] [, \&.\&.\&. ] )
34
changes the definition of a user mapping\&.
36
The owner of a foreign server can alter user mappings for that server for any user\&. Also, a user can alter a user mapping for his own user name if
38
privilege on the server has been granted to the user\&.
43
User name of the mapping\&.
47
match the name of the current user\&.
49
is used to match all present and future user names in the system\&.
54
Server name of the user mapping\&.
57
OPTIONS ( [ ADD | SET | DROP ] \fIoption\fR [\(aq\fIvalue\fR\(aq] [, \&.\&.\&. ] )
59
Change options for the user mapping\&. The new options override any previously specified options\&.
63
specify the action to be performed\&.
65
is assumed if no operation is explicitly specified\&. Option names must be unique; options are also validated by the server\(aqs foreign\-data wrapper\&.
69
Change the password for user mapping
76
ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user \(aqbob\(aq, password \(aqpublic\(aq);
84
conforms to ISO/IEC 9075\-9 (SQL/MED)\&. There is a subtle syntax issue: The standard omits the
86
key word\&. Since both
92
in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also requires it for
93
ALTER USER MAPPING, PostgreSQL diverges from the standard here in the interest of consistency and interoperability\&.
95
CREATE USER MAPPING (\fBCREATE_USER_MAPPING\fR(7)), DROP USER MAPPING (\fBDROP_USER_MAPPING\fR(7))