How to allow Service Account Creation on Databases(Postgres) with special char allowed

[sk]

Hi Team,

We are working service accounts creation on Databases(postgres) and we were able to achieve it successfully. But recently identified that creation of service account is failing when account name consists hypen(-). 

We figured that to allow this special char we need to make the DB statement as below. 

CREATE USER "svc-test1-01042023" WITH PASSWORD 'xxxxxxxx'

Basically if we surround the account name with double quotes (") we were able to create the account.

Now how can we implement it in Saviynt because the Create Account JSON looks like below

{"CreateAccountQry": "CREATE USER ${accountName} WITH PASSWORD '${randompassword}';"}

If I introduce the double quotes around account name it is complaining about JSON format.

{"CreateAccountQry": "CREATE USER "${accountName}" WITH PASSWORD '${randompassword}';"}

We tried surrounding account with single quotes but on DB it is not allowing the special char with single quotes only with Double quotes it is working as expected.

So how can I achieve this?

[rushikeshvartak · Accepted solution]

{"CreateAccountQry": "CREATE USER \"${accountName}\" WITH PASSWORD '${randompassword}';"}