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
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 Its in default Cloud Data base
No, User type is already a system Administrator!
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