The problem described in this KB article has been completely fixed since Plesk 11.5 (see release notes).
Database users cannot create views. This error appears in the DB WebAdmin:
#1142 - CREATE VIEW command denied to user 'db1user'@'localhost' for table 'users_active'
Unable to create routine. The following message is displayed
You do not have the necessary privileges to create a routine
MySQL database users on Parallels Plesk for Windows are not granted the privilege to create and manage views (routines) by default.
To grant permissions to create and manage views (routines) to a database user, follow these steps:
- Log in to Parallels Plesk. Go to Tools & Settings → Database Servers → MySQL Server and open Webadmin.
mysqldatabase, open the
dbtable, and click on Edit in the row of corresponding database users:
- In case of required
viewprivileges switch permissions
Show_view_privto Y and click Go. In case of required
routineprivileges switch permission
Alter_routine_privto Y and click Go.
Switch to the SQL tab of Webadmin, type
and click Go.
After that, the user will be able to create views inside the database.