Changing subscription owner hides this subscription additional web users from the owner in PowerUser view

Create Plesk database backup

Access Plesk database

Get the list of all subscriptions which does not belong to admin:

MYSQL_LIN: mysql> select name, displayName, cl_id from domains where webspace_id=0 and cl_id <> 1;
+-------------+-------------+-------+
| name        | displayName | cl_id |
+-------------+-------------+-------+
| example.com | example.com |   6   |
+-------------+-------------+-------+

Find the user account in psa.smb_users table which belongs to the required client:

MYSQL_LIN: mysql> select id, login, contactName, roleId, ownerId from smb_users where ownerId=6;
+----+----------+-------------+--------+---------+
| id | login   | contactName | roleId  | ownerId |
+----+----------+-------------+--------+---------+
| 4  | johndoe | johndoe      | 26     |    6    |
+----+----------+-------------+--------+---------+
1 row in set (0.00 sec)

where "6" is "domains.cl_id" of the required user from step #3

Change the user owner to admin:

MYSQL_LIN: mysql> update smb_users set ownerId = 1 where id = 4;

where "4" is "smb_users.id" of the required user

Update the "fileSharingUsers" table in order to avoid database inconsistency:

MYSQL_LIN: mysql> insert into fileSharingUsers values ('', 4, 'johndoeuser@example.com', 'NULL');

Assign the user to the required role in Subscriptions > example.com > Users > User Roles or change the owner of this role from customer to admin via CLI:

# plesk bin user --update johndoeuser@example.com -owner admin
SUCCESS: User was successfully updated.

Note: admin is unable to have two roles with the same name

Find the required user account in the "smb_users":

MYSQL_LIN: mysql> select id, login, contactName, roleId, ownerId from smb_users where ownerId=2;
+----+----------+-------------+--------+---------+
| id | login | contactName | roleId | ownerId |
+----+----------+-------------+--------+---------+
| 4 | johndoe | johndoe | 26 | 1 |
+----+----------+-------------+--------+---------+

Find the role name:

MYSQL_LIN: mysql> select * from smb_roles where id=26;
+----+----------+-----------+---------+----------------------+
| id | name | isBuiltIn | ownerId | isActivationRequired |
+----+----------+-----------+---------+----------------------+
| 26 | somerole | 0 | 6 | 0 |
+----+----------+-----------+---------+----------------------+

where "26" is the role "id"

Check if admin has the role with the same name:

MYSQL_LIN: mysql> select * from smb_roles where OwnerId=1;
+----+--------------------+-----------+---------+----------------------+
| id | name | isBuiltIn | ownerId | isActivationRequired |
+----+--------------------+-----------+---------+----------------------+
| 1 | Admin | 1 | 1 | 0 |
| 2 | WebMaster | 0 | 1 | 0 |
| 3 | Application User | 0 | 1 | 0 |
| 4 | Accountant | 1 | 1 | 0 |
+----+--------------------+-----------+---------+----------------------+

If such role does not exist, change the owner to the admin:

MYSQL_LIN: mysql> update smb_roles set ownerId=1 where id=26;