Accessing users from Email Address tab fails with the error: Access denied

Symptoms

1. In Subscriptions > example.com > Email address tab > johndoe@example.com (user column) leads to the User tab showing the error:

   PLESK_ERROR: Access denied.

2. OwnerId in the smb_users table does not match. To verify this find out user ID in the Subscriprions > example.com > Account in the right side - put mouse on a customer and below his id is shown: 

3. Check ID of smb_user mentioned in the e-mail address: 

4. accountId (e-mail user) and ownerId (customer/reseller) do not match to IDs from step 2 and 3 above:

   MYSQL_LIN: mysql> SELECT ownerId from smb_users where id="5";
   +---------+
   | ownerId |
   +---------+
   | 7             |
   +---------+
   1 row in set (0.00 sec)
   
   
   
   
   
   

Cause

Database inconsistency. Incorrect ownerId in smb_users table.

Resolution

1. Connect to the server via SSH

2. Backup Plesk database.

3. Access Plesk database with the command:

   # plesk db 

4. Update the ownerId field:

   MYSQL_LIN: mysql> update smb_users set ownerId=2 where id=5;