How to grant roles usage on security integrations Snowflake

Question

I'm trying to grant usage on a security integration I have created.

GRANT USAGE ON INTEGRATION <integration_name> TO ROLE test_role;

This should be the query that would grant usage, and it runs without error ('Statement executed successfully.'). But it doesn't do anything, I can't get any details on the security integration.

DESC SECURITY INTEGRATION <integration_name>

This is what I would like to run with the test_role, but it still says 'SQL access control error: Insufficient privileges to operate on integration '<integration_name>'.

Is it just not possbile to grant usage on a security integration?

Answer 1

As I see, only the owner of the security integration object can use DESCRIBE command on the object. You may change the ownership and test it:

USE ROLE accountadmin;

grant ownership on INTEGRATION test_integration to role test_role REVOKE CURRENT GRANTS;

USE ROLE test_role;

DESC SECURITY INTEGRATION test_integration;