Dynamic tables: Added support for MONITOR privileges

Attention

This behavior change is in the 2023_08 bundle.

For the current status of the bundle, refer to Bundle History.

To view the metadata of a dynamic table, such as the graph history, refresh history, or attached warehouse, specific privileges are required:

Before the change:

Only SELECT privilege is required.

After the change:

MONITOR privilege is required.

Ref: 1373