MySQL Forums
Forum List  »  MySQL Workbench

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

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

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.