Hi, I have a question regarding to pulum-snowflake...
# general
e
Hi, I have a question regarding to pulum-snowflake. I'm trying to grant SELECT all tables in database to role and it should be done like this in snowflake:
GRANT SELECT ON ALL TABLES IN SCHEMA dbtest.schema1 TO ROLE role_name;
. But in pulumi-snowflake, it seems to be no way to do such thing.
TableGrant
as below:
Copy code
def TableGrant(resource_name: str,
               opts: Optional[ResourceOptions] = None,
               database_name: Optional[str] = None,
               enable_multiple_grants: Optional[bool] = None,
               on_future: Optional[bool] = None,
               privilege: Optional[str] = None,
               roles: Optional[Sequence[str]] = None,
               schema_name: Optional[str] = None,
               shares: Optional[Sequence[str]] = None,
               table_name: Optional[str] = None,
               with_grant_option: Optional[bool] = None)
table_name
type is string, accepting only one table at a
TableGrant
call. Is there a way to grant privilege on ALL tables to role in pulumi-snowflake? Thank you.