Creating materialized query tables
When a materialized query table is created, a 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, 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.
For an ACA exit routine to suppress
unwanted error messages during the creation of materialized query
tables, XAPLFSUP is turned on.