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'
on behalf of my colleague "Channeler" who is clearly too modest to suggest that he may have actually solved the customer's issue ;o)
R1 is the reporting user, it's for read only purposes.
You need to create a custom ticket rule and run your sentence there, watch out when using UPDATE, DELETE or NEW commands, they may render the whole KBOX unstable if it's not used with caution.