Hello everyone. When i try to drop a view on a cloud SQL database, i receive the error:
1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
Problem is... I can't give this privilege to the user (root, by the way!). How can I proceed ?
hiiiii
Could you please confirm if you have altered the users on that instance before?
Have you tested the operation using a different user?
If not, please create a new user and add apply/delete permissions to that user.
Also, could you try to do this on a fresh instance to see if you get the same behavior?