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');
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 userroot
bank?– Jorge.M
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 :)
– Renato Junior
as @Jorgematheus commented, the user who is using to run the update does not have permission, talk to DBA to resolve this
– Ricardo Pontual