由于列"SUBJECTION"，链接服务器“MWSQL"的OLEDB访问接口“MSDASQL”无法INSERTINTO表“[MSDASQL]”。用户没有写入该列的权限。

Question

错误提示：**链接服务器"MYSQL"的 OLE DB 访问接口 "MSDASQL" 返回了消息 "多步 OLE DB 操作产生错误。如果可能，请检查每个 OLE DB 状态值。没有工作被完成。"。
消息 7344，级别 16，状态 1，第 1 行
由于列 "SUBJECTION"，链接服务器 "MYSQL" 的 OLE DB 访问接口 "MSDASQL" 无法 INSERT INTO 表 "[MSDASQL]"。用户没有写入该列的权限。**

;with t1 as(
        SELECT * FROM OPENQUERY([192.163.29.182_mysql], 'SELECT  UUID as USER_ID from kuangshan_admin') 
        except
        SELECT * FROM OPENQUERY([192.163.29.94_mysql], 'SELECT  USER_ID from company_colliery_user')
    )
    insert  OPENQUERY(MYSQL,'select 
    USER_ID,
    cast(SUBJECTION as char) as SUBJECTION,
    cast(DEPARYMENT_ID as char) as DEPARYMENT_ID,
    LOGIN_NAME,
    LOGIN_PASSWORD,
    HPIC_URL,
    USER_NAME,
    USER_IDCARD,
    USER_EMALL,
    OFFICE_PHONE,
    MOBILE_PHONE,
    DUTY,
    REMARK,
    ENABLE_LOGIN,
    IS_LEADER,
    SEQ,
    DEL_FLG,
    INSERT_USER_ID,
    INSERT_DATETIME,
    UPDATE_USER_ID,
    UPDATE_DATETIME
     from company_colliery_user')
    SELECT * FROM OPENQUERY([192.163.29.182_mysql], 'SELECT  
            UUID as USER_ID,
            cast(''735715c6-963c-4a9a-868c-7ceda7a29908'' as char) as SUBJECTION,
            cast(84 as char) as DEPARYMENT_ID,
            user as LOGIN_NAME,
            pass as LOGIN_PASSWORD,
            NULL as HPIC_URL,
            name as USER_NAME,
            '''' as USER_IDCARD,
            '''' as USER_EMALL,
            '''' as OFFICE_PHONE,
            '''' as MOBILE_PHONE,
            deptname as DUTY,
            '''' as REMARK,
            ''1'' as ENABLE_LOGIN,
            ''0'' as IS_LEADER,
            ''1'' as SEQ,
            ''0'' as DEL_FLG,
            ''2001'' as INSERT_USER_ID,
            Now() as INSERT_DATETIME,
            ''2001'' as UPDATE_USER_ID,
            Now() as UPDATE_DATETIME
            from kuangshan_admin where user not in (''admin'',''ddy'')') where USER_ID in(select * from t1);

Answer 1

https://blog.csdn.net/qq86552544/article/details/100160832