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 still shows as Active. Is there another backend table that needs to be updated to completely deactivate a user?

Agile User Asked on January 15, 2021 in Agile PLM (v9).
Add Comment
2 Answer(s)


Your update SQL is right. However, Agile caches user information and so if you do it via DB updates, it wouldn’t know user has changed and hence it isn’t reflecting it. So, for the same user, if you go to UI and modify any attribute and save it, it would show as inactive. Other option is to bounce Agile

In general, it is better to do updates via SDK rather than DB

Hope this helps

– Raj

Agile Expert Answered on January 18, 2021.
Add Comment

Yes, this definitely helps. Thank you for the response.

Agile User Answered on January 21, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.