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
the error says that 'dbadmin' does not have the necessary privileges to execute the INSERT command on the specified table. This could be due to a lack of INSERT privileges or triggers privileges. could you check privileges for the user and change the privileges to admin and run the command again
No, User type is already a system Administrator!