How to disable Alter view statement
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.
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.