bulkGrantPrivilegeToShare
Last updated: January 27, 2026
Grants a privilege on all objects of a specific type within a schema to a Snowflake share. This is a bulk operation that applies the privilege to all existing objects matching the criteria.
Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).
Available attributes
Attribute | Type | Description | Required |
|---|---|---|---|
| String | Name of the share to grant the privilege to | Yes |
| String | Type of objects to grant privilege on* | Yes |
| String | Name of the catalog (database) containing the schema | No |
| String | Name of the schema containing the objects | Yes |
| String | Privilege to grant: | Yes |
* Supported types: TABLE, EXTERNAL_TABLE, ICEBERG_TABLE, DYNAMIC_TABLE
Prerequisites
Before granting bulk privileges on database objects to a share, you must first grant USAGE privilege on the database:
GRANT USAGE ON DATABASE database_name TO SHARE share_name;