DROP USER MAPPING
Section: PostgreSQL 15.6 Documentation (7)
Updated: 2024
Index
Return to Main Contents
NAME
DROP_USER_MAPPING - remove a user mapping for a foreign server
SYNOPSIS
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
CREATE USER MAPPING (CREATE_USER_MAPPING(7)), ALTER USER MAPPING (ALTER_USER_MAPPING(7))
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- PARAMETERS
-
- EXAMPLES
-
- COMPATIBILITY
-
- SEE ALSO
-
This document was created by
man2html,
using the manual pages.
Time: 06:01:22 GMT, April 19, 2024