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