3
PostgreSQL documentation
6
<refentry id="SQL-DROPUSERMAPPING">
8
<refentrytitle id="sql-dropusermapping-title">DROP USER MAPPING</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>DROP USER MAPPING</refname>
14
<refpurpose>remove a user mapping for a foreign server</refpurpose>
17
<indexterm zone="sql-dropusermapping">
18
<primary>DROP USER MAPPING</primary>
23
DROP USER MAPPING [ IF EXISTS ] FOR { <replaceable class="parameter">username</replaceable> | USER | CURRENT_USER | PUBLIC } SERVER <replaceable class="parameter">servername</replaceable>
28
<title>Description</title>
31
<command>DROP USER MAPPING</command> removes an existing user
32
mapping from foreign server.
36
The owner of a foreign server can drop user mappings for that server
37
for any user. Also, a user can drop a user mapping for his own
38
user name if <literal>USAGE</> privilege on the server has been
44
<title>Parameters</title>
48
<term><literal>IF EXISTS</literal></term>
51
Do not throw an error if the user mapping does not exist. A
52
notice is issued in this case.
58
<term><replaceable class="parameter">username</replaceable></term>
61
User name of the mapping. <literal>CURRENT_USER</>
62
and <literal>USER</> match the name of the current
63
user. <literal>PUBLIC</> is used to match all present and
64
future user names in the system.
70
<term><replaceable class="parameter">servername</replaceable></term>
73
Server name of the user mapping.
81
<title>Examples</title>
84
Drop a user mapping <literal>bob</>, server <literal>foo</> if it exists:
86
DROP USER MAPPING IF EXISTS FOR bob SERVER foo;
92
<title>Compatibility</title>
95
<command>DROP USER MAPPING</command> conforms to ISO/IEC 9075-9
96
(SQL/MED). The <literal>IF EXISTS</> clause is
97
a <productname>PostgreSQL</> extension.
102
<title>See Also</title>
104
<simplelist type="inline">
105
<member><xref linkend="sql-createusermapping" endterm="sql-createusermapping-title"></member>
106
<member><xref linkend="sql-alterusermapping" endterm="sql-alterusermapping-title"></member>