Materialized query tables

When a materialized query table is created, a create view (CRTVUAUTT) authorization check is performed.

The CRTVUAUTT check is used to determine whether the creator of a materialized query table can provide the required SELECT privileges on base tables to the owner of the materialized query table. If the owner of the materialized query table has the required privileges, then the CRTVUAUTT authorization check proves redundant. However, the check is performed before the owner of the materialized query table's privileges are determined. Therefore, if the materialized query table owner holds the necessary privileges and the creator of the materialized query table does not, the CRTVUAUTT check can produce unwanted error messages. To suppress these unwanted error messages, XAPLFSUP is turned on to indicate that the RACF access control module should suppress these messages.