Hello,
I am struggling trying to assign permission dynamically on a schema. I am using databricks asset bundle and I have a parametrized script to assign permission.
grant select on schema {{schema}} to {{group}};
I cannot achieve a dynamic grant statement. I also tried running on a notebook something like
execute immediate 'grant select on schema ? to ?' using ('my_schema', '`my_group`');
but unfortunately this does not work. From docs it seems it can be achievable with IDENTIFUER clause, I tried also that but without success. It throws syntax error.
It this achievable in some way or not? Thanks in advance.
