Provider Resource to Manage Grant on COMMAND

[mswanson-mastery]

Hey folks,

We are onboaring a data governance tool and one of the permissions it requires is usage on the SHOW IMPORTED KEYS command - I cannot find a single provider def in the docs to manage this - other than an unsafe execute.

We have no qualms about using that to grant usage on the command, but I'm curious if there are other definitions I could use to accomplish this?

Thanks!

[sfc-gh-jcieslak]

Hey @mswanson-mastery 👋
To be honest, that's the first time I've seen this command/privilege. Just so you know, we are basing our knowledge on the public documentation, so If anything is missing, we won't have it in the provider (I already reported it, and it should be added to the official documentation). Could you provide an SQL example of how you would like to grant usage on that command? As a workaround for now, you can use unsafe_execute that uses raw SQL.