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'
Any solution?
Thanks
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
Hobbsy
5 years ago
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.
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. - Channeler 5 years ago