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

[SANDEEP1]

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.

[Manu269]

@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

[SANDEEP1]

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.

[rushikeshvartak]

Use saviynt REST Connector for Use data manipulation 

[sk]

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

[SANDEEP1]

Hi Saathvik, 

Thanks for replay,

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

[SANDEEP1]

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

[rushikeshvartak]

You can use saviynt4Saviynt REST APIs using standard REST Connector