Confluence creates a USERINFO for all users from JIRA

When using a JIRA user directory, Confluence creates a USERINFO in the table content for all users, whether they have permissions to use Confluence or not. Only users with have (or may be had) can use permission should have a profile Confluence.

If you have a big user base in JIRA and only a few have the right to use Confluence, this can be annoying as all users will appear in the people directory or in mentions.

Workaround:

1. Shutdown Confluence.
2. In your database server, run the following query to identify the id of your JIRA user directory:

   delete from content where contenttype='USERINFO' and username in (
   SELECT DISTINCT
       (users.lower_user_name)
   FROM
       cwd_user users
   JOIN
       cwd_directory userdir
   ON
       users.directory_id=userdir.id
   WHERE
       userdir.id=<ID_from_step_#2>
   AND users.lower_user_name NOT IN
                             (
                             SELECT DISTINCT
                                 lower(permusername)
                             FROM
                                 SPACEPERMISSIONS
                             WHERE
                                 permtype='USECONFLUENCE')
   OR  users.lower_user_name NOT IN
       (
           SELECT
               u.lower_user_name
           FROM
               cwd_user u
           JOIN
               cwd_directory d
           ON
               u.directory_id = d.id
           JOIN
               cwd_membership m
           ON
               u.id = m.child_user_id
           JOIN
               cwd_group g
           ON
               g.id = parent_id
           JOIN
               SPACEPERMISSIONS sp
           ON
               g.lower_group_name =lower(sp.permgroupname)
           WHERE
               permtype='USECONFLUENCE' )
   AND users.active='T'
   AND userdir.active='T');
   

3. Start Confluence
4. Long in to Confluence and rebuild your search index:
   1. Go to Browse > Confluence Admin.
   2. Click on Content Indexing on the left-hand side menu, under the heading Administration.
   3. Click on Rebuild in your Search Index panel.