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

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