Unable to write to the source due to system error. Error Details: INSERT command denied to user 'dbadmin'@'%' for table `dbo`.`CM_AUDIT`

Unable to write to the source due to system error. Error Details: INSERT command denied to user 'dbadmin'@'%' for table `dbo`.`CM_AUDIT`

Facing Above error when trying to insert data to CM_RECORD Table  After Creating Trigegr using below SQL code

CREATE TRIGGER `Audit` AFTER INSERT ON `CM_RECORD` FOR EACH ROW BEGIN

INSERT INTO dbo.CM_AUDIT
(COMPLAINT_ID, ENTITY_TYPE, CREATED_BY, CREATED_ON)
VALUES
(`CM_RECORD.COMPLAINT_ID`,`CM_RECORD`, SUSER_SNAME(), GETDATE());
END

  Discussion posts and replies are publicly visible

Parents Reply Children