Dropping a user mapping

When a user no longer needs access to a remote data source, you can drop the user mapping between the federated server and the remote data source server. If the user is mapped to more than one data source server, you must drop each mapping separately.

Before you begin

If the authorization ID is different from the federated database user ID that is specified in the user mapping, ensure that you have SYSADM or DBADM authority.. .

Procedure

Use one of the following methods:

  • Command line:

    Issue the DROP statement.

    DROP USER MAPPING FOR user_ID SERVER local_server_name
    where:
    • user_ID is the authorization ID for the user on the federated server
    • local_server_name is the local name that is used to identify the remote data source server in the server definition.
  • Web console:
    1. Click Administer > Remote Tables.
    2. Click Manage Servers.
    3. Click Manage User Mappings.
    4. Select one or more users.
    5. Click Drop.