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 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2

Got it figured out...simply removed the KBSYS.  from KBSYS.DELL_ASSET worked

Answered 02/05/2013 by: geofft
Senior White Belt

  • I ran in to the same issue today, and your solution worked for me. Thanks!
  • Ran into the same issue today and came across your post. It worked like a charm and the issue resolved in no time. Thanks.
Please log in to comment
Answer this question or Comment on this question for clarity