SET CONNECTION

Use the SET CONNECTION command to define the host access records for Netezza Performance Server clients. These records specify which Netezza Performance Server system connections use an SSL connection.

The host access records define how Netezza Performance Server clients connect to the Netezza Performance Server system by using either secured or unsecured connections. Use this command to insert and delete rows from the system table. For a complete description of how to configure SSL connections for Netezza Performance Server client users, see the IBM® Netezza® System Administrator’s Guide.

Syntax

Syntax for setting a connection.
SET CONNECTION { LOCAL | HOST | HOSTSSL | HOSTNOSSL }
DATABASE { '<database_name>' | 'ALL'}
[ IPADDR '<ip_address>' ]
[ IPMASK '<ip_address_mask>' ]
[ AUTH 'auth_type']

Inputs

The SET CONNECTION command takes the following inputs:
Table 1. SET CONNECTION inputs
Input Description
LOCAL Define a connection record for users who connect to Netezza Performance Server by using UNIX sockets.
HOST Define a connection record for users who connect to Netezza Performance Server over IP by using either secured or unsecured SSL connections.
HOSTSSL Define a connection record for users who connect to Netezza Performance Server over IP by using only secured SSL connections.
HOSTNOSSL Define a connection record for users who connect to Netezza Performance Server over IP by using only unsecured SSL connections.
database_name | ALL The name of the database to which the client users at the specified IP address or range have connection access. Specify ALL to match on all databases. The value ALL indicates that the user can attempt to connect to any of the databases on the Netezza Performance Server system; however, the user account object permissions control the database objects that the user is permitted to view.
ip_address The IP address for the client system; applies to HOST, HOSTSSL, and HOSTNOSSL connection types.
ip_address_mask The IP address mask for the client system; applies to HOST, HOSTSSL, and HOSTNOSSL connection types.
auth_type The authentication mode for the connection. If the mode is set to LOCAL, you can select from the following types:
  • MD5 (default)
  • TRUST
  • CRYPT
  • PASSWORD
  • SHA256

Outputs

The SET CONNECTION command has the following outputs:
Table 2. SET CONNECTION outputs
Output Description
SET CONNECTION The command was successful.
ERROR: permission denied You do not have the necessary privileges.

Privileges

You must be an administrator, or an administrator give you the Manage System privilege, to issue this command.

Usage

The following examples provide sample usage.
SET CONNECTION HOST DATABASE 'ALL' IPADDR '192.168.0.0'
IPMASK '255.255.255.0';