Previous Topic: Input Parameter SyntaxNext Topic: List Roles By User: Sample Report Input


Input Parameters

SYSID

Specifies the SYSID or SYSID mask of the system or systems whose information is processed for the report. The SYSID parameter can contain a specific SYSID value, or it can contain a masked value requesting information from more than one system.

The masking supported for this value follows DB2 SQL request masking:

Limits: one to eight characters

Example: SYSID(SI%) requests that the compliance report include information for any system whose SYSID value begins with the characters ‘SI’.

USERID, ALLUSERS, GLOBALID, ALLGBLS

One of the following parameters is required. They are mutually exclusive, so only one can be specified.

USERID

Specifies a userid for which the roles will be listed.

ALLUSERS Y|N

Lists all userids with the roles that are connected to each userid.

Default: N

GLOBALID

Specifies a global ID for the report request. All of the userids associated with the global ID are listed, with the roles that are connected to each userid.

ALLGBLS Y|N

Lists all global IDs. For each global ID, each userid associated with the global ID is listed, with the roles that are connected to the userid.

Default: N

USERNAME Y|N

(Optional) Specifies that the NAME associated with each userid should be displayed in the report.

Default: N

DATES Y|N

(Optional) Specifies that any active and expire dates for a role, as well as any userid’s expire date for a role, should be displayed in the report.

Default: N

LINECNT number_

(Optional) Specifies the number of lines per page in the report.

Default: 60

Limits: numbers from 10 to 999999999999999999

DATES Y|N

(Optional) Specifies that any active and expire dates for a role, as well as any userid's expire date for a role, and the user expire date associated with each ACID, should be displayed in the report. If the date displayed is determined to be past the system CURRENT DATE, an *EXPIRED* message is displayed next to the date value on the report.

Default: N