When I am logged in as
rds_user and have following privileges:
GRANT SELECT, INSERT, UPDATE, DROP ONnews
.* TO 'rds_user'@'%'
My code runs
INSERT command just fine, but when it gives ProgrammingError it executes
UPDATE instead. However,
UPDATE command errors out with
1142 (42000): UPDATE command denied to user 'rds_user'@'XX.XX.XX.XX' for table 'data'
data is a table in db
I tried granting privilege again and flushed privileges, still same error. I am using Python's sql connector to send the commands. Genuinely confused on what is going