How to Deactivate users through SQL

Question

How to Deactivate users through SQL

I tried the following query: UPDATE AGILEUSER set ENABLED=0 where LOGINID =’xxxx’. When I check in the Agile UI it …

CharuV Agile User Asked on January 15, 2021 in Agile PLM (v9).

205 views
2 answers
0 votes

Answer 1

Hello Did you update the loginid in agileuser table? If so, there could be an issue. Reason is Agile generates...

Answer 2

Hello Once you get the IDataobject, you can do a setValue For example iwf.setValue(ChangeConstants.ATT_COVER_PAGE_DATE_ORIGINATED, new Date()); Hope this helps Raj

Answer 3

Sandeep, Seems like you haven't updated the new password. Check if the updated database password and RCU password are correct...

Answer 4

I wanted to give an update here, now that I have more or less solved my issue. The MultiList03 attribute...

Answer 5

This select has worked for me, but I don't think it gets the Mfr info. v_id NUMBER(10,0) := NULL; v_class...

Answer 6

Hello Did you update the loginid in agileuser table? If so, there could be an issue. Reason is Agile generates...

Answer 7

Hello Once you get the IDataobject, you can do a setValue For example iwf.setValue(ChangeConstants.ATT_COVER_PAGE_DATE_ORIGINATED, new Date()); Hope this helps Raj

Answer 8

Sandeep, Seems like you haven't updated the new password. Check if the updated database password and RCU password are correct...

Answer 9

I wanted to give an update here, now that I have more or less solved my issue. The MultiList03 attribute...

Answer 10

This select has worked for me, but I don't think it gets the Mfr info. v_id NUMBER(10,0) := NULL; v_class...

LATEST ANSWERS

How to Deactivate users through SQL