Symptoms

When any of the three methods to to access the page restrictions dialog box are used the page restrictions dialog box does not pop up.

The following appears in the atlassian-confluence.log:

ERROR [http-8080-24] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
 -- url: /pages/getpagepermissions.action | userName: xxxxxx | referer: http://confluence.zzzzz.com/display/space_name/page_name
java.lang.IllegalArgumentException: No such user: [yyyyy]

Cause

There are users in the content perm table that do not exist in the cwd_user table.  This is most likely due to the incorrect deletion of users.

Resolution

Find those users that have orphaned permissions

SELECT *
FROM content_perm
WHERE username NOT IN (SELECT user_name FROM cwd_user)

Ensure that the users that appear in your list of results should re removed them. Make sure you have a backup of your database before you start removing things

1. Remove them a user at a time - Preferred solution

   DELETE FROM content_perm
   WHERE username = <user_name>

2. Remove Everything.

   DELETE
   FROM content_perm
   WHERE username NOT IN (SELECT user_name FROM cwd_user)

For good measure it is a good idea to flush your browser cache and perform a res-sync on your user directories.