To modify the permissions of a MySQL database user, perform the following steps:
1 – Logged in to Plesk.
2 – Go to Databases.
3 – Click User Management.
4 – Select the database user name.
5 – To allow read access or write access only, select the corresponding role (Read Only or Write Only).
6 – You can select the name of the database that the user will access, or selecting Any for a universal database user.