Snowflake Information Schema views: New column GRANTED_TO

Attention

This behavior change is in the 2024_07 bundle.

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

When this behavior change bundle is enabled, the following views in the Snowflake Information Schema include a new column:

  • OBJECT_PRIVILIGES

  • TABLE_PRIVILEGES

  • USAGE_PRIVILEGES

The new column in these views is:

Column name

Data type

Description

GRANTED_TO

VARCHAR

Object that has been granted the privilege. Possible values currently include ROLE, APPLICATION, and APPLICATION ROLE.

The GRANTED_TO column appears after the GRANTEE column.

Ref: 1753