Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/21/2024 01:37 AM
Hello community,
We have a issue configuring the field CREATEACCOUNTJSON.
This is our configuration: (Is this syntax I provided good ? )
{
"CreateAccountQry": [
"CALL CREAT_ACCOUNT('${accountName}', '${password}', 'master')"
]
}
CREAT_ACCOUNT is store procedure in SQL db, this store procedure accepts 3 parameters:
accountName should be the account name obtained using the name rule on the endpoint and generated during ARS process. (example value dbtest-user1 )
password should be auto-generated using password policy (20-25 characters)
'master' should be hard coded string value
This is the error I get :
SAV - Error while creating account - dbtest-user1- Exception occured in Create Account Query - Incorrect syntax near 'dbtest-user1'.
Solved! Go to Solution.
06/21/2024 02:15 AM - edited 06/21/2024 02:17 AM
@itinjic try like below format without ][:
{
"createaccountqry": "call createaccount(${user.id}, '${user.displayname}', '${user.email}', '${user.employeeid}', '${user.firstname}','${user.lastname}','${user.systemusername}', '${user.username}','${randompassword}')"
}
06/21/2024 02:44 AM
Hi @itinjic, can you try passing without square bracket?
06/21/2024 06:17 AM
06/21/2024 06:56 AM
I fixed it
{
"CreateAccountQry": [
"EXEC [master].[dbo].[CREAT_ACCOUNT] '${accountName}', '${password}', 'master'"
]
}
06/21/2024 07:33 AM
Yes in Saviynt you need to use EXEC instead of CALL
06/21/2024 08:48 AM
Yes but example is really poorly written in connector and documentation, it's very confusing.
Connector:
database_connector_guide.pdf
06/23/2024 09:11 PM
provide feedback on documentation article