[Feature]: When granting privileges to a share, we need options for all the various table types

[pslking]

Company Name

No response

Use Cases or Problem Statement

When granting privileges to a share, we can grant privileges on all TABLES in a schema to the share, but we can't grant to all other table types, such as DYNAMIC TABLES, EXTERNAL TABLES, and ICEBERG TABLES.

Category

category:grants

Object type(s)

resource:grant_privileges_to_share

Proposal

Requesting additional options similar to the on_all_tables_in_schema for the other types, or perhaps a list, set, or map.

e.g.
on_object_types_in_schema = [ "DYNAMIC TABLES", "ICEBERG TABLES", "EXTERNAL TABLES" ]

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @pslking. I will add this to our backlog. It shouldn't be a big change, but either way, we will probably address it after V1.