User priveleges create and modify Views

[Björn Koenen]

Hello,

I am new to MySQL, till now I worked with MS SQL.

I created a User in MySQL Workbench that only can Create and Modify views, so that this user can't mess up the tables or delete tables.

When I want to modify a View with this user, I get the error message that this user requires the DROP privilege, but then he can drop every table?

ERROR 1142: DROP command denied to user 'user_query'@'localhost' for table 'TEST_ARTICLE'

Is there a way to specify more in detail user privileges, because I think MySQL Workbench is very basic for defining the user privileges.

Kind regards,

Björn