DQ Internal Security › Limiting Access to Rows Using Conditions and Restrictions › Condition/Restriction Reporting (DQCRRPT) › Restriction Reports

Restriction Reports

├── REPORT ─ TITLE=RESTRICTION ─┬────────────────────┬────────────────────────►
                                └─ ,TABLE=tablename ─┘

 ►─┬────────────────────────────────────────────────────────────┬─────────────►◄
   ├─ USER ─ NAME=userid ───────────────────────────────────────┤
   └─ GROUP ─ LEVELS= ─┬─ level1 ─┬─────────────────────────┬─┬─┘
                       │          └─ ,level2 ─┬───────────┬─┘ │
                       │                      └─ ,level3 ─┘   │
                       └─ ALL ────────────────────────────────┘

REPORT Statement

The Restriction REPORT statement follows the SIGNON statement in the job stream. The control statement REPORT is formatted as follows:

1-10

Identifies the type of control statement. The valid entry is REPORT.

11-72

Specifies the option keywords and their values. All Conditions within a Restriction are listed on a Restriction Report. The valid entries are:

TITLE=

(Required) Specifies the type of report to be executed.

Valid Entries: RESTRICTION

Default Value: (No default)

,TABLE=

(Optional) Specifies the name of the table to be reported.

Valid Entries: A 1- to 9-character table name

Default Value: All tables are reported.

Any table named on REPORT statement applies to USER and GROUP statements that follow. The default is ALL.

There are no spaces in the keyword portion of the statement. An equal sign (=) separates an option type from its value, and a comma separates the options. Do not enter options past column 72.

USER and GROUP Statements

The optional USER or GROUP statement is formatted as follows:

1-10

Identifies the type of control statement. Valid entries are USER and GROUP.

11-72

Specifies the option keywords and their values, as described next:

NAME=

Identifies the userid to be reported. NAME= is required if a USER statement is coded.

Valid Entries: A CA Dataquery userid

Default Value: All users are reported

LEVELS=

Specifies one to three group names to be reported. LEVELS= is required if a GROUP statement is coded. To report on all groups, code LEVELS=ALL or omit the GROUP statement.

Valid Entries: A CA Dataquery userid

Default Value: All users are reported

There are no spaces in the keyword portion of the statement. An equal sign (=) separates an option type from its value, and a comma separates the options. Do not enter options past column 72. If no USER or GROUP statements are coded, CA Dataquery reports all restrictions. You can use multiple USER and GROUP statements following the REPORT statement.