I am trying to edit code in mysql workbench but I am getting an error for user R1 Error Code: 1142. SELECT command denied to user 'R1'@'nrsranch-it01.goropin.local' for table 'HD_TICKET_CHANGE'

I have changed the password for R1 to verify it is the correct password. 

I am trying to create a report that will show how many tickets were closed by 2 users in a year time frame sorted by month

SELECT T.ID, T.CREATED, T.TIME_CLOSED, OWNER.FULL_NAME as "Owner", 
CLOSED.TIMESTAMP, CLOSED.DESCRIPTION,
CLOSER.FULL_NAME as "Closer"
FROM ORG1.HD_TICKET T
LEFT JOIN HD_TICKET_CHANGE CLOSED ON CLOSED.HD_TICKET_ID = T.ID and CLOSED.DESCRIPTION like '%Changed ticket Status from%to "Closed"%'
LEFT JOIN USER OWNER ON OWNER.ID = T.OWNER_ID
LEFT JOIN USER CLOSER ON CLOSER.ID = CLOSED.USER_ID
WHERE T.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 24 HOUR)
AND (CLOSER.USER_NAME = "jwinn" or CLOSER.USER_NAME = "twinn")

This is one I have for daily tickets
1 Comment   [ + ] Show Comment

Comments

  • Can you run other queries without that error? If not, check to make sure that "Enable database access" is checked in Security Settings.
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share