Privileges: WITH GRANT OPTION No Longer Allowed When Granting Privileges to Shares¶
This behavior change is in the 2023_04 bundle.
For the current status of the bundle, refer to Bundle History.
The behavior of the GRANT <privileges> … TO SHARE command is as follows:
You could specify the WITH GRANT OPTION when granting privileges to a share.
You cannot specify the WITH GRANT OPTION when granting privileges to a share.
Snowflake returns the following error message:
Unsupported feature 'GRANT PRIVILEGES TO SHARE WITH GRANT OPTION'.