IT18741: SELECT <TABNAME> FROM <TABNAME> SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED

APAR status

• Closed as fixed if next.

Error description

• select <tabname> from <tabname> returns all rows of the table as
  a rowtype.
  
  If you create a table, and revoke the permissions, the select
  <tabname> from <tabname> will not work.
  However as soon as you grant select permissions to one column,
  the select <tabname> from <tabname> will return all
  rows of the table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users using the OP_ROWVAR function with specific column      *
  * access granted on the table.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Users should update to IDS 11.70.xC9 to solve this problem.  *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP