LISTING_ACCESS_HISTORY view: New columns¶

Attention

This behavior change is in the 2024_05 bundle.

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

When this behavior change bundle is enabled, the LISTING_ACCESS_HISTORY view includes the following new columns:

Column name	Data type	Description
IS_SHARE	BOOLEAN	TRUE if the access was on a share. When TRUE, the LISTING_OBJECTS_ACCESSED column provides details about the share objects accessed by the consumer query.
IS_APPLICATION	BOOLEAN	TRUE if the access was on an application. When TRUE, APPLICATION_OBJECTS_ACCESSED column provides details about the application objects accessed by the consumer query.
SHARE_OBJECTS_ACCESSED	ARRAY	See LISTING_OBJECTS_ACCESSED array for formatting. Is NULL when IS_SHARE is FALSE. Note: this column has the same data as the LISTING_OBJECTS_ACCESSED column. It is recommended to use SHARE_OBJECTS_ACCESSED instead of LISTING_OBJECTS_ACCESSED as it may be deprecated in the future.
APPLICATION_OBJECTS_ACCESSED	ARRAY	See APPLICATION_OBJECTS_ACCESSED Array for formatting. Is NULL when IS_APPLICATION is FALSE.
APPLICATION_PACKAGE_NAME	VARCHAR	The current name of the application package from which the application was installed. Is NULL when IS_APPLICATION is FALSE.
APPLICATION_VERSION	VARCHAR	The version of the application when this query occurred. Is NULL when IS_APPLICATION is FALSE.
APPLICATION_PATCH_ID	INTEGER	The patch number of the application when this query occurred. Is NULL when IS_APPLICATION is FALSE.

APPLICATION_OBJECTS_ACCESSED Array¶

The APPLICATION_OBJECTS_ACCESSED array provides details about the objects in an application accessed by a consumer query. The format of an item in the array depends on the type of object that was accessed.

Note

Object IDs are not available and database names are masked.

Functions¶

{
  "argumentSignature": (function_signature varchar),
  "objectName": "23662386A408C571B77FDC53691793E4992D1C12.SCHEMA_NAME.FUNCTION_NAME",
  "objectDomain": "Function"
}

Copy

Stored procedures¶

{
  "argumentSignature": (function_signature varchar),
  "objectName": "23662386A408C571B77FDC53691793E4992D1C12.SCHEMA_NAME.PROCEDURE_NAME",
  "objectDomain":"Procedure"
}

Copy

Tables, views, and columns¶

[
  {
    "Columns": [
      {
        "columnName": "column1_name"
      },
      {
        "columnName": "column2_name"
      }
    ],
    "objectDomain":"VIEW",
    "objectName": "5F3297829072D2E23B852D7787825FF762E74EF3.PUBLIC.VIEW_1"
  },
  {
    "Columns": [
      {
        "columnName": "column3_name"
      },
      {
        "columnName": "column4_name"
      }
    ],
    "objectDomain":"TABLE",
    "objectName": "D85A2CE1531C6C1E077FA701713047305BDF5A83.PUBLIC.TABLE1"
  }
]

Copy

Ref: 1641