SHOW CONNECTION

Use the SHOW CONNECTION command to display the connection records that are defined for the Netezza Performance Server client users.

Syntax

Syntax for showing current authentication configuration:

SHOW CONNECTION

Input

There are no inputs for the SHOW CONNECTION command.

Outputs

The SHOW CONNECTION command has the following outputs:

Table 1. SHOW AUTHENTICATION outputs
Output	Description
`SHOW CONNECTION`	The command was successful.
`ERROR: permission denied`	You do not have the necessary permission to view the results of this command.

Privileges

You must be an administrator or must have the following privileges:

The Manage System privilege.
The List and Select privileges on the view _v_connection.

Usage

Sample usage with output follows.

MYDB.SCH1(USER)=> 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
      4 | hostnossl | ALL    | 192.168.1.2 | 255.255.255.255 | md5
(4 rows)