Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

USER Statement

USER Statement

Use the USER statement to authorize the specified user and, optionally, IP address, to connect to PowerExchange.
Optionally, on Linux, UNIX, and Windows, use the USER statement to authorize the specified user to issue pwxcmd and infacmd pwx commands. On Windows, use the USER statement authorize users to issue PowerExchange Listener commands through the PowerExchange Navigator. The maximum statement length is 64 characters.
The USER statement has the following syntax:
USER=(user_ID[@
domain
]       ALLOW={F|N|Y}       [AUTHGROUP=
group_id
]       [IP=
nnnn
.
nnnn
.
nnnn
.
nnnn
]       [TASKCNTRL={D|S}]      )
The USER statement has the following parameters:
user_id
[@
domain
]
Required. Specifies the user ID of a user. Optionally, on Windows, you can specify a domain name. User ID checking is case-sensitive.
You can use the following wildcard characters in the user ID:
  • Asterisk (*), which represents 0 or more characters.
  • Question mark (?), which represents exactly one character.
If the user ID contains an asterisk (*) or question mark (?) character as a part of the ID, precede these characters with the tilde (~) escape character.
The user specifications on a pwxcmd command and the USER statement in the sign-on file must match. If you specify a domain as part of a user ID in the sign-on file, you must also specify the domain in the user ID when you issue an infacmd pwx or pwxcmd command.
If you do not specify a domain as part of a user ID in a infacmd pwx or pwxcmd command, PowerExchange assumes that the user ID is local or a member of the same domain as the user ID under which the PowerExchange Listener runs. If you run the PowerExchange Listener as a Windows service and that service runs under the local user, you must specify the domain as part of a user ID in an infacmd pwx or pwxcmd command.
ALLOW={F|N|Y}
Required. Specifies one of the following values:
  • F
    . Indicates that additional ALLOW parameters follow.
  • N
    . The user cannot connect on to the PowerExchange. If an IP address is specified, the user is restricted from that IP address only.
  • Y
    . The user can connect to PowerExchange from any IP address, unless a specific IP address is specified in the IP parameter.
AUTHGROUP=
group_ID
On Linux, UNIX, or Windows, specifies the name of the authorization group to which this user is assigned. This name must match the authorization group name specified in a corresponding AUTHGROUP statement, which authorizes the users in the authorization group to issue one or more pwxcmd and infacmd pwx commands.
IP=
nnnn
.
nnnn
.
nnnn
.
nnnn
Optional. Specifies an IP address of a user. The
nnnn
value of an IP address, called an octet, is a number from 0 through 255.
If the last octet of the IP address is zero, then PowerExchange uses the octet values to cover number from 0 to 255. For example, the following IP parameter specification covers all IP addresses from 10.10.10.0 to 10.10.10.255:
IP=10.10.10.0
If an octet begins with zero, then PowerExchange assumes the value specified is octal. For example, if you specify 0120, PowerExchange coverts this value to 80. Generally, you should specify decimal numbers for the octet values.
TASKCNTRL={D|S}
Optional. On Windows, authorizes the user to issue the LISTTASK or STOPTASK command from the PowerExchange Navigator. Valid values are:
  • D
    . The user can issue the LISTTASK command from the PowerExchange Navigator.
  • S
    . The user can issue the STOPTASK command from the PowerExchange Navigator.
This option is valid only if SECURITY=(1,Y) in the DBMOVER configuration file.
To issue a command from the PowerExchange Navigator, click
TASK_CNTL
in the
DB Type
list in the
Database Row Test
dialog box.