CA Culprit in the CA IDMS/DB Environment › PROFILE Parameter › PROFILE Parameter

PROFILE Parameter

More information:

PROFILE Parameters

Purpose

Override system defaults, and supply the ID and password of the user.

Syntax

      Col
      2
      ▼         ┌──────────────────────────────┐
►►─── PROfile ──▼─┬─ profile-options ────────┬─┴──────────────────────────────►◄
                  ├─ site-specific-options ──┤
                  └─ error-options ──────────┘

Syntax Rules

Except as described below, the syntax rules described in PROFILE Parameter, apply to CA Culprit runs in a CA IDMS/DB database environment:

USER = user-id

Identifies an authorized user:

• At an installation where CA Culprit security is enabled, the user must be defined to the data dictionary. The ADD USER DDDL statement defines a user to the Integrated Data Dictionary (IDD).

  Note: For more information, see the CA IDMS IDD DDDL Reference Guide.

• To access or create a table, the user must either be the owner of the table or have passkey authorization for the table.

  Note: For more information about passkey authorization, see the CA IDMS ASF User Guide.

User-id is a 1- to 32-character alphanumeric value. If user-id contains blanks or special characters (that is, other than letters, numbers, or hyphens), it must be enclosed in single quotation marks.

Note: For more information on special coding considerations that apply to a user defined to CA-ICMS, see the CA IDMS ASF User Guide.

PW = password

Identifies the password associated with the user named on the PROFILE parameter. The password is established in the data dictionary using the PASSWORD IS password clause of the ADD USER DDDL statement.

Note: For more information, see the CA IDMS IDD DDDL Reference Guide.

At a CA-ICMS installation, CA-ICMS verifies whether the password is valid and approves or denies access accordingly.

Password is a unique 1- to 8-character value; if special characters are used (that is, characters other than letters, numbers, or hyphens), the password must be enclosed in single quotation marks. Hexadecimal literals must appear in the form X'password-string'; for example, PW=X'0102030405'.

The password does not appear on any CA Culprit listings. If no password is associated with the user named on the PROFILE parameter, PW=password can be omitted or password can be coded as a blank enclosed in single quotation marks (that is, PW=' ').

Usage

CA Culprit establishes the user and password coded on the PROFILE parameter as the default values for the CA Culprit run. Users can override these values in a run that accesses tables by coding user and password information on either the INPUT or OUTPUT parameter.

Examples

Sample PROFILE parameters are shown and described below.

Example 1

PROFILE USER=GSR PW=POSSUM
INPUT DB SS=EMPSS01,EMPSCHM,100

Before CA Culprit can access records from a database for which security is enabled, CA Culprit passes the user name GSR and password POSSUM to IDD for validation.

Example 2

PROFILE USER=EYH PW=RAGTIME
INPUT TABLE=PARTS TYPE=COPY OWNER=LHN LOCATION=ASFDICT

To access table PARTS, CA Culprit passes the user's ID and password to IDD for verification. Since the owner of PARTS is EYH, CA Culprit must determine whether user EYH has been issued passkey authorization to access the table.