how to inactivate local users in the database without inactivating LDAP users

[Shannon Davis]

I have a large group of users that came over in an import - local users. We're using LDAP.  To disable them all, it takes a long time as for each person I edit and make inactive, the screen has to reload the search results.  I was thinking it would be easier to do a query in the DB and update them that way.

I found this but I wanted to make sure it didn't inadvertently in-activate any LDAP accounts so I wanted to add a qualification for that (if there is something that tells you if the account is LDAP or local).

update cwd_user set active = 0 where user_name in (test1, test2);

I was going to change it to this:

update cwd_user set active = 0 where user_name like 'c_%';

Has anyone done this?

[Paulo Hennig]

Hello Shannon, 

Users from your LDAP and Local JIRA users have specific directories ids. You can check with the query:

SELECT * FROM cwd_directory

Now that you already know their directory ids, you can just run the query:

UPDATE cwd_user SET active = 0 where cwd_directory = (directory id from users you want to set as inactive users)