[[{“value”:”A second data mart was introduced as part of the last round of Technology Refreshes that allows me to capture and store information about the special authorities given to user profiles in my partitions.
The Special Authority Data Mart is held in the table SPECIAL_AUTHORITY_DATA_MART, which resides in the SYSTOOLS. The table is a Materialize Query Table, MQT. This means that the contents of the table are not dynamic, changed when changes are made to the user profiles, it is refreshed using the REFRESH TABLE SQL statement. If you don’t know what that is I will show how to use it in my examples below.
The most basic SQL statement to retrieve the data from the Table is:
01 SELECT * FROM SYSTOOLS.SPECIAL_AUTHORITY_DATA_MART
Read more »”}]] Read More
