How to view complete SQL Server DB Logs

[harishyara]

Hello Team,

We have an issue where DB record is getting inserted into SQL Server Database from Saviynt, but when adding DB roles using Add Access JSON, roles are not getting mapped. Please be note that this is working in lower instance but it's not working in prod.

Here is the DB Add Access JSON SQL Query - 

INSERT INTO [dbo].[USER_ROLES_TABLE] ([roleid] ,[userid]) VALUES ('${task.entitlement_valueKey.entitlement_value}' , '${user.username}');

Is there any config which we need to add in DB connection level to view the logs to see the actual insert query after values are evaluated/parsed just like INSERT INTO [dbo].[USER_ROLES_TABLE] ([roleid] ,[userid]) VALUES ('R01' , 'Tom');

Thanks,

Harish

[Manu269]

@harishyara refer this post for sample values :

 JSON - Handling Special Characters in DB connectio... - Saviynt Forums - 50545

Grant Access JSON template for MSSQL server - Saviynt Forums - 46674

Ideally you shoud be able to see the results in logs itself.

Also can you try passing hardcoded value and see if it works?

[rushikeshvartak]

make typo in json