SELECT command denied to user 'R1'@'localhost' after updating K1000 to 5.4.70402
Getting an error on report PC by ship date.
SQL error shows us this: mysql error: [1142: SELECT command denied to user 'R1'@'localhost' for table 'DELL_ASSET'] in EXECUTE("SELECT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, DA.SERVICE_TAG, DA.SHIP_DATE,M.USER_LOGGED AS LAST_LOGGED_IN_USER FROM KBSYS.DELL_ASSET DA LEFT JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) WHERE M.CS_MANUFACTURER LIKE '%dell%' AND M.BIOS_SERIAL_NUMBER!='' AND DA.DISABLED != 1 ORDER BY DA.SHIP_DATE")
Verified R1 and password is default. Any ideas on how to correct?
Thanks,
Geoff
Answers (1)
Got it figured out...simply removed the KBSYS. from KBSYS.DELL_ASSET worked
Comments:
-
I ran in to the same issue today, and your solution worked for me. Thanks! - InaJeep 11 years ago
-
Ran into the same issue today and came across your post. It worked like a charm and the issue resolved in no time. Thanks. - nitikasinghgaba 10 years ago