Saviynt Forums

dpannem0804 · 05/24/2022

I am using below statement in create account json to create a account /role in postgresql db but I am getting below error . I don't see any much information in log, Could you please confirm that if we can use create statement in create account json....

dpannem0804 · 05/25/2022

I tried with below hardcode value still getting same error.{"CreateAccountQry": " create Role \"test999\" WITH CREATEDB CREATEROLE LOGIN "}and also tried with below one.{"CreateAccountQry": " create Role test999 "} {"log":"2022-05-25 14:19:27,411 [q...

dpannem0804 · 05/25/2022

I dont find any error codes apart from that which shared .Yes I am able to execute same query in db and able to create user /role. for ex : CREATE ROLE akibit WITHLOGINNOSUPERUSERINHERITNOCREATEDBNOCREATEROLENOREPLICATION;GRANT readwrite TO akibit;

dpannem0804 · 05/25/2022

it seems there is no option to attached logs here , hence i am posting log below. "Service Name","Date Timestamp","Message""ecm-worker","2022-05-25T14:21:01.240+0000","{"log":"2022-05-25 14:21:00,911 [quartzScheduler_Worker-10] DEBUG provisoning...

dpannem0804 · 05/25/2022

Thanks for your reply.I tried with below different combinations still getting same error. {"createAccountQry" : ["create Role '${user.systemUserName}' WITH CREATEDB CREATEROLE LOGIN"]}or{"createAccountQry": " create Role \"test999\" WITH CREATEDB CRE...

dpannem0804 · 05/25/2022

Thanks for your reply.I tried with below hardcode value still getting same error.{"CreateAccountQry": " create Role \"test999\" WITH CREATEDB CREATEROLE LOGIN "}and also tried with below one.{"CreateAccountQry": " create Role test999 "} {"log":"2022...

Online Status	Offline
Date Last Visited	‎05/25/2022 03:16 PM

Saviynt Forums

User Statistics

User Activity

Postgresql DB - Create Account JSON issue

Re: Postgresql DB - Create Account JSON issue

Re: Postgresql DB - Create Account JSON issue

Re: Postgresql DB - Create Account JSON issue

Re: Postgresql DB - Create Account JSON issue

Re: Postgresql DB - Create Account JSON issue