Parameters › Security Parameters › EXTSECSQLSUFFIX Parameter

EXTSECSQLSUFFIX Parameter

This parameter specifies the suffix for all security resource names that CA OPS/MVS defined for the SQL security event.

Thus, you can choose between two formats for the SQL security event:

EXTSECSUFFIX=TBL - table name only

<prefix>.SQL.<table>

Or

EXTSECSUFFIX=TBL.CMD - table name and a command type

<prefix>.SQL.<table>.<cmdtype>

Where <prefix> is the specified or defaulted parameter EXTSECPREFIX value.

Default value

TBL

Other possible values

TBL.CMD

Set or modify this parameter...

At initialization

Example: EXTSECSQLSUFFIX=TBL

Then, you attempt to create a table named ‘NEWTAB’:

The SQL resource name generated in the CA OPS/MVS security event is:

<prefix>.SQL.NEWTAB

with an access type of UPDATE

Then, you insert data into the table ‘NEWTAB’; the resource name is the same:

<prefix>.SQL.NEWTAB

with an access type of UPDATE

Now, suppose you select from data from the table ‘NEWTAB’; the resource name is the same:

<prefix>.SQL.NEWTAB

The access type is now READ.

Example: EXTSECSQLSUFFIX=TBL.CMD

Then, you attempt to create a table named ‘NEWTAB’:

The SQL resource name generated in the CA OPS/MVS security event is:

<prefix>.SQL.NEWTAB.CT

with an access type of UPDATE

Then, you insert data into the table ‘NEWTAB’; the resource name is the same:

<prefix>.SQL.NEWTAB.IN

with an access type of UPDATE

Now, suppose you select from data from the table ‘NEWTAB’; the resource name is the same:

<prefix>.SQL.NEWTAB.SE

The access type is READ.

Where <prefix> is the specified or defaulted parameter EXTSECPREFIX value.

Possible CMD type values:

For more information, see the CA OPS/MVS Security Guide.