Privileges: WITH GRANT OPTION No Longer Allowed When Granting Privileges to Shares¶

Attention

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:

Previously:

You could specify the WITH GRANT OPTION when granting privileges to a share.

Currently:

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'.

Ref: 1096