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?
Hello
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
