Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

yogesh2
Regular Contributor
Regular Contributor

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.