Show connection records

In IBM Netezza Appliance and IBM Netezza Appliance, there is a set of predefined connection records. To list the current set of connection records, use the SHOW CONNECTION command.

The command displays a connection ID to uniquely identify each connection record. A sample command follows:

SYSTEM.ADMIN(ADMIN)=> SHOW CONNECTION;
 CONNID | CONNTYPE  | CONNDB | CONNIPADDR  |   CONNIPMASK    | CONNAUTH
--------+-----------+--------+-------------+-----------------+--------
      1 | local     | all    |             |                 | trust
      2 | host      | all    | 127.0.0.1   | 255.255.255.255 | md5
      3 | host      | all    | 0.0.0.0     | 0.0.0.0         | md5
(3 rows)

In the sample output, the connection requests define the following capabilities:

Connection ID 1 specifies that the Netezza Performance Server host accepts connection requests from any local user (someone that is logged in directly to the Netezza Performance Server) to all databases.
Connection ID 2 specifies that the host accepts either secured or unsecured connection requests from any local user (connecting through IP) to all databases.
Connection ID 3 specifies that the host accepts either secured or unsecured connection requests from any remote client user (connecting through IP) to any database.

Important: The host might accept a connection request, but the user must still pass account authentication (user name and password verification), and have permissions to access the requested database.

The first record that matches the client connection information is used for authentication. If the first chosen record does not work, the system does not look for a second record. If no record matches, access is denied. With the default records previously shown, any client user who accesses the Netezza Performance Server system and has correct user account and password credentials is allowed a connection; they can request either secured or unsecured connections, as the Netezza Performance Server host accepts either type.