ASF Row-Level Security Reports—IREPORTS › ASF Row-Level Security Reports

ASF Row-Level Security Reports

Sample IREPORT 001:

  REPORT NO.  01                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  1
  IREPORT 001                                         ROW LEVEL SECURITY SUMMARY REPORT

  TABLE.:  BUDGET2                                   TDN...:     247                                SECURITY NAME:      QALPASS
  OWNER.:  QAL

  USER                          WHERE CLAUSE
  ----                          ------------
  QAD                           JAN GT 10000

Sample IREPORT 002:

  REPORT NO.  02                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  1
  IREPORT 002                                         ROW LEVEL SECURITY DETAIL REPORT

  TABLE.:  BUDGET2                                   TDN...:     247                                SECURITY NAME:      QALPASS
  OWNER.:  QAL

      USER..:  QAD                                       GROUP.:
      STATUS:  (V) VALIDATED
      WHERE.:  JAN GT 10000

Sample IREPORT 003:

  REPORT NO.  03                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  1
  IREPORT 003                                     ROW LEVEL SECURITY SUMMARY REPORT BY USER

  ROW LEVEL SECURITY ACCESS FOR USER.:       QAC                                                     SECURITY NAME:      QALPASS

  TABLE              OWNER                  SECNAME      TDN  WHERE CLAUSE
  -----              -----                  -------- -------  ------------
  DEMO               JSS                    DEMO123      137  LNAME = 'ABC'

  REPORT NO.  03                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  2
  IREPORT 003                                     ROW LEVEL SECURITY SUMMARY REPORT BY USER

  ROW LEVEL SECURITY ACCESS FOR USER.:       QUAD                                                    SECURITY NAME:      DEMO123

  TABLE              OWNER                  SECNAME      TDN  WHERE CLAUSE
  -----              -----                  -------- -------  ------------
  BUDGET2            QAL                    QALPASS      247  JAN GT 10000
  SMALLTAB           QAL                    QALPASS2     260  ACCOUNT EQ '1'

  REPORT NO.  03                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  3
  IREPORT 003                                     ROW LEVEL SECURITY SUMMARY REPORT BY USER

  ROW LEVEL SECURITY ACCESS FOR USER.:       QAG                                                    SECURITY NAME:      SECURROW

  TABLE              OWNER                  SECNAME      TDN  WHERE CLAUSE
  -----              -----                  -------  -------  ------------
  ROW LEVEL          QAP                    SECURROW     223  COL1 = 69

Sample IREPORT 004:

  REPORT NO.  04                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  2
  IREPORT 004                                     ROW LEVEL SECURITY DETAIL REPORT BY USER

  ACCESS FOR USER.:  QAD                                 GROUP:

  TABLE.:  BUDGET2                                                                 TDN:     247         SECNAME    QALPASS
  OWNER.:  QAL
  WHERE.:  JAN GT 10000
  STATUS:  (V) VALIDATED

  TABLE.:  SMALLTAB                                                                TDN:     260         SECNAME:   QALPASS2
  OWNER.:  QAL
  WHERE.:  ACCOUNT EQ '1'
  STATUS:  (V) VALIDATED

Sample IREPORT 005:

  REPORT NO.  05                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  1
  IREPORT 005                             ROW LEVEL SECURITY SUMMARY REPORT BY OWNER/SECURITY NAME

  OWNER.........:  QAC
  SECURITY NAME.:  DEMO123

  TABLE NAME            TDN  USER                    WHERE CLAUSE
  ----------         ------ ------                   ------------
  DEMO                  137  QAC                     LNAME = 'ABC'

  REPORT NO.  05                                    INFORMATION CENTER MANAGEMENT SYSTEM                         mm/dd/yy  PAGE  2
  IREPORT 005                             ROW LEVEL SECURITY SUMMARY REPORT BY OWNER/SECURITY NAME

  OWNER.........:  QAD
  SECURITY NAME.:  QALPASS

  TABLE NAME            TDN  USER                    WHERE CLAUSE
  ----------          -----  ---                     ------------
  BUDGET2               247  QAD                     JAN GT 10000

Field Descriptions

TABLE

Name of a table for which row-level security is established.

OWNER

Owner of the table.

TDN

Table definition number of the table.

SECURITY NAME (SECNAME)

Security name assigned to the table.

USER

Id of a user authorized to access certain rows of the table.

WHERE

Specifies criteria that define the data that the user is permitted to see. If a user has unlimited access to the table (that is, no WHERE clause exists), the following literal appears:

*** NO RESTRICTIONS ***

STATUS

Specifies whether the $SECURITY-RUNTIME-TABLE$ entry has been validated; that is, whether user, owner, security name, and WHERE criteria are entered correctly in the $SECURITY-RUNTIME-TABLE$ table. The report generates the following messages:

• (V) VALIDATED
• (I) REQUIRES VALIDATION
• (E) ERROR IN VALIDATION

GROUP

Name of the group that has authority to access the table.