Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/24/2024 02:00 AM - edited 06/24/2024 02:14 AM
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.
06/24/2024 09:48 PM
Does command directly working in DB ?
06/25/2024 01:04 AM
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.
06/27/2024 03:08 AM