Best Practices Question
What user can i use to make a SQL update?
I am trying to do this:
select * from ASSET where name ='XXX'
select * from ASSET_STATUS
select * FROM ASSET LEFT JOIN ASSET_STATUS ON ASSET_STATUS.ID = ASSET.ASSET_STATUS_ID
update ASSET set ASSET_STATUS_ID = '500' where name ='XXXX'
But I have this error:
UPDATE command denied to user 'R1'@'XX.XX.XX.XXX' for table 'ASSET'