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
Is this in a separate DB schema?
Did you follow this: docs.appian.com/.../appian-cloud-database-administration.html
No Its in default Cloud Data base
If you create that trigger and include a "DEFINER" clause, you might end up with this kind of issue.
How dbo. is default cloud db