Cannot drop views from Cloud (my) SQL, even as root

Google Cloud Database
1

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 ?

2

hiiiii

3

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?

  1. Create a totally new, fresh database.
  2. Connect to the database as root@%.
  3. Run the Insert/Delete/Drop query and see.
1 Like