Grant Access JSON template for MSSQL server

[shubhangsinha_]

Hello everyone,

I am trying to find grant access json for provisioning roles in external MS SQL server database but there seems to be no sample for it : 

The only sample I see is but this seems to be for internal Saviynt database : 

{

"ENTITLEMENT_TYPE1" : [
"DELETE FROM USER_SAVROLES where USERKEY
= ${user.id}" 

}

[pmahalle]

Hi @shubhangsinha_ ,

You can use below template for grant access, change the query as per the requirement and your target MSSQL DB schema.

{
"entitlement_type1": "insert into tablename (col1, col2, col3) Values ('${accountName}',  '${task.entitlement_valueKey.entitlement_value}', '${task.entitlement_valueKey.customproperty7}')"
}

[shubhangsinha_]

Thank you for your response but In the entitlement_type1 query I have to mention the actual name of the entitlement type? or should I just leave it as such