To Modify Database User Privileges.
1. Log in to your Spaceweb control panel.
2. Select Databases from the navigation menu. All the operational databases in your Plesk account and related options will appear.
3. Click on User Management.
A list of active database users will show up.
4. Click on the name of the database user to change its privileges.
A form with customization settings for the user account is displayed.
Scroll down and, you will spot the Privileges section divided as Data Access and Structure Access.
5. Select the privileges you want to grant the user and click the OK button at the end form.
This is how we can grant user privileges to a database.