Updated on 2023-10-23 GMT+08:00

DROP USER MAPPING

Function

DROP USER MAPPING drops a user mapping for a foreign server.

Syntax

DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name;

Parameter Description

  • IF EXISTS

    Reports a notice instead of an error if the user mapping does not exist.

  • user_name

    Specifies user name of the mapping.

    CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all current and future user names in the system.

  • server_name

    Specifies name of the server to which the user is mapped.