View in MYSQL 5

I would also like to know how to solve this. Can the web hosting provider somehow setup cPanel to automatically give the "create view" privilegie when the user has the "create" privilegie?

Also, why is there not a checkbox for the "Create View" privilegie in Cpanel?

 

Looks like these feature is not considered in the security arquitecture of cpanel + phpmyadmin combination, create view works like the creation of a new database from the phpmyadmin perspetive?, (simply we cant do that, or a user could create infinite number of databases)

Some one have any experience with these?

Best Regards

Roy

 

The easyway to get around it is to add the create view privilege for the user to that particular database using phpmyadmin in WHM.

I dont think this poses a security issue because it only allows the customer to create a view on a database he has access to. I'm guessing its just an oversight by the cpanel developers and it needs including.

Can anyone confirm this?

Edit, I did this successfully for one user recently but I'm trying to do it again and the privilege isnt available in the list.

 

Sorry to dig up an old thread, but having the same problem this produced a solution for us. Hope this information can help someone else out.

After upgrading from 4.1 to 5, we had the same issues as outlined in this thread. create view would produce a permission denied error. Viewing the current privileges produced errors.

Running the script :

/usr/bin/mysql_fix_privilege_tables

Allowed us to edit user privileges again using phpymyadmin through WHM (not cpanel). After loading this up we were able to edit the user and enable the select and view commands. This fixed the problem for us. oddly running a standard "grant all" command form the mysql prompt did not, even after the privilege table had been repaired.