TABLE_PRIVILEGES View: Update GRANTOR column value in the consumer account (Postponed)


This behavior change is in the 2023_07 bundle.

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

This behavior change was originally planned for September, 2023; however, it has been postponed and a new release date has not been determined.

This change is not available for testing.

For the most up-to-date details about the release date, as well as other release-related details, see the Behavior Change Log.

The Information Schema TABLE_PRIVILEGES view behaves as follows:

Before the change

When a consumer creates a database from a share and queries the Information Schema TABLE_PRIVILEGES view, the GRANTOR column in the view specifies the name of the role in the provider account that made the grant to the share.

After the change

If the consumer queries the TABLE_PRIVILEGES view and the GRANTOR column contains a role from the provider account that made the grant on the table to the share, Snowflake removes this row from the view output.

Ref: 1321