Account Usage Views: New OPTIONS Column in Select Views

Attention

This behavior change is in the 2023_04 bundle.

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

The following ACCOUNT_USAGE views include the OPTIONS column:

  • MASKING_POLICIES

  • ROW_ACCESS_POLICIES

The OPTIONS column indicates whether a policy has the EXEMPT_OTHER_POLICIES property set to TRUE or FALSE:

  • If the property is set to TRUE, the OPTIONS column returns {“EXEMPT_OTHER_POLICIES”: “TRUE”}.

  • If the property is set to FALSE or the property is not specified in the policy, the OPTIONS column returns NULL.

Ref: 1091