MySQL Forums
Forum List  »  MySQL Workbench

User priveleges create and modify Views
Posted by: Björn Koenen
Date: September 28, 2021 06:06AM


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,


Options: ReplyQuote

Written By
User priveleges create and modify Views
September 28, 2021 06:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.