IBM Support




The SPECIAL_AUTHORITY_DATA_MART table is a data mart that contains information about special authorities for users. These authorities can come directly from a user profile or can be obtained through membership in a group profile.

This data mart is implemented as a materialize query table (MQT). The data in this table is only populated and refreshed when requested by a user. This is done by using the REFRESH TABLE SQL statement.


You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > SYSTOOLS.SPECIAL_AUTHORITY_DATA_MART
For complete detail, visit this IBM Documentation page: SYSTOOLS.SPECIAL_AUTHORITY_DATA_MART table

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"}]

Document Information

Modified date:
07 May 2024