II12330: CHANGES TO DB2 SQL REFERENCE SC26-3270-00 THAT DID NOT MAKE V4.1 GA PUBS. CONTINUATION OF II09159

APAR status

• INTRAN

Error description

• 5740xyr00 DB2 R410 V4    continuation of II09159
  This APAR documents changes to the DB2 SQL Reference
  SC26327000 which did not make Version 4.1 GA pubs.
  ================================================================
  Version 4 Book Title: SQL Reference
  Pages: 389 and 400
  
  Change Description:
  For the REVOKE statement, revise the last paragraph of the
  "Cascade Revoke" usage note, which appears at the bottom
  of page 389, to:
  
  |   Revoking a SELECT privilege that was exercised to
  |   create a view causes the view to be dropped, unless
  |   the owner of the view was directly granted the SELECT
  |   privilege from another source before the view was
      created. Revoking a SYSADM privilege that was required
      to create a view causes the view to be dropped. For
      details on when SYSADM authority is required to
      create a view, see Authorization in "CREATE VIEW".
  
  For the REVOKE (table or view) statement, revise the
  description of SELECT, which appears at the bottom of
  page 400, to:
  
      SELECT
      Revokes the privilege to use the SELECT statement.
  |   A view is dropped when the SELECT privilege that was
  |   used to create it is revoked, unless the owner of
  |   the view was directly granted the SELECT privilege
  |   from another source before the view was created.
  ============================================================
  

Local fix

Problem summary

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