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
SET CONNECTION { LOCAL | HOST | HOSTSSL | HOSTNOSSL }
DATABASE { '<database_name>' | 'ALL'}
[ IPADDR '<ip_address>' ]
[ IPMASK '<ip_address_mask>' ]
[ AUTH 'auth_type']
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:
|
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
SET CONNECTION HOST DATABASE 'ALL' IPADDR '192.168.0.0'
IPMASK '255.255.255.0';