@PROM_NSEC_DEF Table

When new objects are introduced as a result of a target or remote promotion, the access permissions assigned to those objects use default values pre-specified in the @PROM_NSEC_DEF table. This table is parameterized by source node name; therefore, the default parameters vary for different change requests depending on their source.

Object Types

Ensure that your system has one occurrence in @PROM_NSEC_DEF for each of the object types eligible for promotion. A list of eligible objects can be obtained by browsing the table @PROM_OBJTYPES or pressing PF1 in the Object Type field of the Query Promotion Information screen.

Customizing the @PROM_NSEC_DEF Table

To customize this table, use the Single Occurrence Editor. The following example illustrates an occurrence for screen objects in the @PROM_NSEC_DEF table.

--- SINGLE OCCURRENCE EDITOR ---

EDITING TABLE : @PROM_NSEC_DEF

TABLE TYPE : TDS

COMMAND ==>

------------------------------------------------------------------------------

PFKEYS: 1=HELP 2=DOCUMENTATION 3=END 12=CANCEL 13=PRINT 22=DELETE

Field Values

The parameter fields are described as follows:


OBJECT_TYPE	Must be an object type eligible for promotion. Refer to @PROM_NSEC_DEF Table for a list of valid object types.
READ	Specifies if users have read access to an object type. Applies to table data only. Valid values are Y (access) or N (no access).
INSERT	Specifies if users have insert access to an object type. Applies to table data only. Valid values are Y (access) or N (no access).
REPLACE	Specifies if users have replace access to an object type. Applies to table data only. Valid values are Y (access) or N (no access).
DELETE	Specifies if users have delete access to an object type. Applies to table data only. Valid values are Y (access) or N (no access).
DEFINE_VIEW	Specifies if users can define subview (SUB) tables, and calculation (CLC) tables. Applies to table definition only. Valid values are Y (yes) or N (no).
DEFINE_PRMTBL	Specifies if users can define parameter (PRM) tables. Applies to table definition only. Valid values are Y (yes) or N (no).
MODIFY_DEFN	Specifies if users can modify the definitions of an object type. Applies to table, screen, and report definitions. Valid values are Y (yes) or N (no).
VIEW_DEFN	Specifies if users can view the definitions of an object type. Applies to table, screen, and report definitions. Valid values are Y (yes) or N (no).
DISPLAY	Specifies if users are able to display screens. Valid values are Y (yes) or N (no).
PRINT	Specifies if users can print reports. Valid values are Y (yes) or N (no).
AUTHOR	Specifies the default value for the creator of the object type. If this field has a null value, that is, it is blank, the same value carried over from the source system is used in the target. This also applies to the creation date. If the value is the NULL literal, the author and creation date attributes of an object are set to blanks or nulls. Any other value is used as the author attribute and the creation date is set to the current date.
MODIFIER	Specifies the default value for the modifier of the object type. The two values null and literal NULL are the same as in the AUTHOR field.
CLASSIFICATION	Specifies the security level of the object type. Type one of the following levels: 1 – All users with clearance of 1 or greater can access the object. 7 – Only users with clearance of 7 can access the object.
OWNER	Specifies the default value for the owner of the object type. This is the creator of the object and an individual user ID is expected. The information in this field is used for security purposes.
LOG_ACCESSES	Specifies if user accesses to the object type are recorded. Applies only to tables. Valid values are Y (yes) or N (no); N is the default. N is recommended. With Y, every access to the table in question is recorded in the audit log.