Initialization Parameters › Initialization Parameter Descriptions › SECLIST

SECLIST

This parameter specifies whether selection lists are to be limited to data accessible to the user.

Syntax:

SECLIST=NONE|ALL|REPORT,INDEX,DEFINE, JOB

The default is NONE.

Values are as follows:

NONE

Indicates that all of the selection list data is presented to the user, and accessibility is determined after the user selects the data.

ALL

Indicates that all of the selection lists are to be limited to data accessible by the user.

REPORT, INDEX, DEFINE, JOB

Identifies specific selection lists that are to be limited to data accessible to the user.

REPORT

Indicates the SYSOUT/Report Selection List.

INDEX

Indicates the Index Name and Value Selection Lists.

DEFINE

Indicates the User, SYSOUT, Distribution, Device, Filter, and View Definition Selection Lists.

JOB

Indicates the Job Selection List.

Note: The JOB designation is supported only on databases that are versioned to 12.2 or higher.

You can specify any combination of REPORT, INDEX, DEFINE, or JOB.

Important! Specifying a SECLIST value other than none greatly increases the number of security calls and may affect overall system performance.