From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/drop_user_mapping.sgml | 110 ++++++++++++++++++++++++++++++++ 1 file changed, 110 insertions(+) create mode 100644 doc/src/sgml/ref/drop_user_mapping.sgml (limited to 'doc/src/sgml/ref/drop_user_mapping.sgml') diff --git a/doc/src/sgml/ref/drop_user_mapping.sgml b/doc/src/sgml/ref/drop_user_mapping.sgml new file mode 100644 index 0000000..9e8896a --- /dev/null +++ b/doc/src/sgml/ref/drop_user_mapping.sgml @@ -0,0 +1,110 @@ + + + + + DROP USER MAPPING + + + + DROP USER MAPPING + 7 + SQL - Language Statements + + + + DROP USER MAPPING + remove a user mapping for a foreign server + + + + +DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERVER server_name + + + + + Description + + + DROP USER MAPPING removes an existing user + mapping from foreign server. + + + + The owner of a foreign server can drop user mappings for that server + for any user. Also, a user can drop a user mapping for their own + user name if USAGE privilege on the server has been + granted to the user. + + + + + Parameters + + + + IF EXISTS + + + Do not throw an error if the user mapping does not exist. A + notice is issued in this case. + + + + + + user_name + + + User name of the mapping. CURRENT_ROLE, CURRENT_USER, + and USER match the name of the current + user. PUBLIC is used to match all present and + future user names in the system. + + + + + + server_name + + + Server name of the user mapping. + + + + + + + + Examples + + + Drop a user mapping bob, server foo if it exists: + +DROP USER MAPPING IF EXISTS FOR bob SERVER foo; + + + + + Compatibility + + + DROP USER MAPPING conforms to ISO/IEC 9075-9 + (SQL/MED). The IF EXISTS clause is + a PostgreSQL extension. + + + + + See Also + + + + + + + + -- cgit v1.2.3