We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

How to update user attributes through custom query in EIC V23.11

SANDEEP1
New Contributor
New Contributor

I tried to update users Customproperty using select query in new EIC V23.11 environment. Error "INSERT OR UPDATE operation on USERS table is not allowed" is displayed.

Suggest the alternative way to update the user attributes using Custom query job.

7 REPLIES 7

Manu269
All-Star
All-Star

@SANDEEP1 

Restrictions:

You cannot perform any insert or update operation on the following tables:

  • Users

  • configuration

  • p_history

  • userlogin_Access

  • userloginAccess

  • qrtz_blob_triggers

  • qrtz_calendars

  • qrtz_cron_triggers

  • qrtz_fired_triggers

  • qrtz_job_details

  • qrtz_locks

  • qrtz_paused_trigger_grps

  • qrtz_scheduler_state

  • qrtz_simple_triggers

  • qrtz_simprop_triggers

  • qrtz_triggers

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Thanks for the update,

Recently the update has launced, i had refered the docs as well. 

can you kindly suggest the way to update the users table based on the conditions.

Use saviynt REST Connector for Use data manipulation 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

sk
All-Star
All-Star

@SANDEEP1 : What is your use case? Can you use SAV4SAV REST?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

SANDEEP1
New Contributor
New Contributor

Hi Saathvik, 

Thanks for replay,

My requirment is to update users column with the values in DATASET, based on some conditions.

SANDEEP1
New Contributor
New Contributor

After update from v23.11 we cannot use SAV4SAV connection. correct me if i'm wrong.

You can use saviynt4Saviynt REST APIs using standard REST Connector


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.