ALTER CONNECTION

Purpose

Use this statement to change the connection data of an external connection.

Prerequisite

At least one of the following prerequisites must be fulfilled:

  • User has the system privilege ALTER ANY CONNECTION
  • The connection is granted to the user with the WITH ADMIN OPTION
  • The connection belongs to the current user or one of the user’s roles

Syntax

alter_connection::=

Alter Connection

Alter Connection

Examples

ALTER CONNECTION ftp_connection
      TO 'ftp://192.168.1.1/'
      USER 'agent_008'
      IDENTIFIED BY 'secret';
ALTER CONNECTION exa_connection TO '192.168.6.11..14:8564';
ALTER CONNECTION ora_connection TO '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.54)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))';