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.