My problem is that when I try appending to the Workorder table, I get the error message listed below. I am very experienced using action queries and I am able to append data to other MYSQL tables on my server. In order to attempt fix the problem I ran an SQL statement to grant this table to public, but this didnt help, even though and I am able to run "select" queries against the workorder table and I am logged in as sysadm.
What can I do to fix this problem? Below is my error message and SQL insert query:
ODBC--insert on a linked table 'SYSADM_WORK_ORDER' failed. [GUPTA][ODBC Driver][SQLBase]011502 SEC SVI security violation attempting to access WORK_ORDER (#1102)
Code: Select all
INSERT INTO SYSADM_WORK_ORDER ( TYPE, BASE_ID, LOT_ID, SPLIT_ID, SUB_ID, PART_ID, GLOBAL_RANK, DESIRED_QTY, RECEIVED_QTY, CREATE_DATE, DESIRED_RLS_DATE, DESIRED_WANT_DATE, CLOSE_DATE, COSTED_DATE, STATUS, COPY_FROM_SPLIT_ID, ENGINEERED_BY, ENGINEERED_DATE, DRAWING_ID, DRAWING_REV_NO, PRODUCT_CODE, COMMODITY_CODE, FORWARD_SCHEDULE, POSTING_CANDIDATE, MAT_GL_ACCT_ID, LAB_GL_ACCT_ID, BUR_GL_ACCT_ID, SER_GL_ACCT_ID, VARIABLE_TABLE, ENTITY_ID, SCHEDULE_GROUP_ID, SCHED_START_DATE, SCHED_FINISH_DATE, COULD_FINISH_DATE, EST_MATERIAL_COST, EST_LABOR_COST, EST_BURDEN_COST, EST_SERVICE_COST, ACT_MATERIAL_COST, ACT_LABOR_COST, ACT_BURDEN_COST, ACT_SERVICE_COST, REM_MATERIAL_COST, REM_LABOR_COST, REM_BURDEN_COST, REM_SERVICE_COST, MARKED_FOR_PURGE, PRINTED_DATE, DRAWING_FILE, WAREHOUSE_ID, WIP_VAS_REQUIRED, ALLOCATED_QTY, FULFILLED_QTY, DEF_LBL_FORMAT_ID, HARD_RELEASE_DATE, USER_1, USER_2, USER_3, USER_4, USER_5, USER_6, USER_7, USER_8, USER_9, USER_10, UDF_LAYOUT_ID ) SELECT d.TYPE, d.BASE_ID, d.LOT_ID, d.SPLIT_ID, d.SUB_ID, d.PART_ID, d.GLOBAL_RANK, d.DESIRED_QTY, d.RECEIVED_QTY, d.CREATE_DATE, d.DESIRED_RLS_DATE, d.DESIRED_WANT_DATE, d.CLOSE_DATE, d.COSTED_DATE, d.STATUS, d.COPY_FROM_SPLIT_ID, d.ENGINEERED_BY, d.ENGINEERED_DATE, d.DRAWING_ID, d.DRAWING_REV_NO, d.PRODUCT_CODE, d.COMMODITY_CODE, d.FORWARD_SCHEDULE, d.POSTING_CANDIDATE, d.MAT_GL_ACCT_ID, d.LAB_GL_ACCT_ID, d.BUR_GL_ACCT_ID, d.SER_GL_ACCT_ID, d.VARIABLE_TABLE, d.ENTITY_ID, d.SCHEDULE_GROUP_ID, d.SCHED_START_DATE, d.SCHED_FINISH_DATE, d.COULD_FINISH_DATE, d.EST_MATERIAL_COST, d.EST_LABOR_COST, d.EST_BURDEN_COST, d.EST_SERVICE_COST, d.ACT_MATERIAL_COST, d.ACT_LABOR_COST, d.ACT_BURDEN_COST, d.ACT_SERVICE_COST, d.REM_MATERIAL_COST, d.REM_LABOR_COST, d.REM_BURDEN_COST, d.REM_SERVICE_COST, d.MARKED_FOR_PURGE, d.PRINTED_DATE, d.DRAWING_FILE, d.WAREHOUSE_ID, d.WIP_VAS_REQUIRED, d.ALLOCATED_QTY, d.FULFILLED_QTY, d.DEF_LBL_FORMAT_ID, d.HARD_RELEASE_DATE, d.USER_1, d.USER_2, d.USER_3, d.USER_4, d.USER_5, d.USER_6, d.USER_7, d.USER_8, d.USER_9, d.USER_10, d.UDF_LAYOUT_ID FROM d;
