SQL command denied to user selector

Asked

Viewed 28 times

2

I am trying to update my database, and set the Visible of all these vouchers to 0, I am using ide for the command and it accuses an error and I believe it is at syntax, someone can help me?

UPDATE command denied to user 'selector'@'135.127.72.253' for table 'voucher'

UPDATE voucher
SET visible = 0
WHERE (city_name = 'Manaus' AND campus_name = 'Nucleo');
  • 4

    In the error it is very explicit what is happening: The 'selector' user is not allowed to execute a update. You would have access to the user root bank?

  • Welcome to Stack Overflow in English, I edited your question to make it easier for us to understand. I recommend visiting the [tour] to know a little more how the Stack Overflow works. Welcome :)

  • 1

    as @Jorgematheus commented, the user who is using to run the update does not have permission, talk to DBA to resolve this

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.