Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Snowflake grant access is not working

SanyaGoswami
New Contributor
New Contributor

I created "Add Access" task from the ARS to the Snowflake Endpoint.
When I ran the provisioning Job, the entitlement was not provisioned in Snowflake.

GrantAccessJSON:
------------------------------
{
"ROLE": [
"GRANT ROLE \${task.entitlement_valueKey.entitlement_value}\ TO USER \${accountName}\ "
]
}

I'm receiving an insufficient privileges error in Saviynt (see attached error log). However, when I use the same service account to add the role in the Snowflake console, the role is granted successfully.

error_snowflake.png

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

Does command directly working in DB ?


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

yogesh2
Regular Contributor II
Regular Contributor II

what is the hardcoded query that you are trying to execute? if it contains \ then you might need to escape it.

I have created a SQL Server connection in past and had to escape \ by using 8 backslashes instead of one.