/build/static/layout/Breadcrumb_cap_w.png
02/22/2019 262 views

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

Comments

  • 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.

All Answers

1

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.

Answered 02/26/2019 by: Hobbsy
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share