MySQL Forums
Forum List  »  MySQL Workbench

How to disable Alter view statement
Posted by: sreekanth pm
Date: March 13, 2018 05:19AM

I am using mysql work bench 6.3. When I try to alter views, right click on the view and select alter view the output displays with create algorithm syntax.The DEFINER column refers to the user who had created the view earlier. Since I am not having the super privileges I am unable to execute the syntax with old definer name,it works fine when i replace it with my connection name.

Do we have any settings in work bench to disable the definer and execute the alter statement.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to disable Alter view statement
767
March 13, 2018 05:19AM


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.