Saviynt Forums

SANDEEP1 · 12/01/2023

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.

SANDEEP1 · 12/01/2023

UPDATE usersSET customproperty20 =CASEWHEN customproperty12 = 'employee' AND EXISTS (SELECT attribute2 FROM dataset_valuesWHERE customproperty11 LIKE CONCAT('%', attribute1, '%') AND datasetkey = 4) THEN(SELECT attribute2 FROM dataset_valuesWHERE cus...

SANDEEP1 · 11/09/2023

Hi ,I need to update the customproperty of an user with the values present in the datasets.Help me with the query to update the user customproperty with the values present in the datasets.

SANDEEP1 · 12/03/2023

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

SANDEEP1 · 12/03/2023

Hi Saathvik, Thanks for replay,My requirment is to update users column with the values in DATASET, based on some conditions.

SANDEEP1 · 12/01/2023

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.

SANDEEP1 · 12/01/2023

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.

Online Status	Offline
Date Last Visited	‎12/04/2023 02:46 AM

Saviynt Forums

User Statistics

User Activity

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

Enhanced query execution

Update the user customproperty path with the value present in datasets.

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

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

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

Re: Enhanced query execution