Skip to main content
Known Participant
Nov 28, 2023 3:25 PM UTC
Question

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

    6 replies

    stefanhelzle0001
    Brainy
    Nov 28, 2023 8:18 PM UTC

    Is this in a separate DB schema?

    Did you follow this: docs.appian.com/.../appian-cloud-database-administration.html

    Known Participant
    Nov 29, 2023 12:52 PM UTC

    No Its in default Cloud Data base

    stefanhelzle0001
    Brainy
    Nov 29, 2023 12:57 PM UTC

    If you create that trigger and include a "DEFINER" clause, you might end up with this kind of issue.

    karumurua531442
    Participating Frequently
    Nov 29, 2023 4:05 AM UTC

    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

    Known Participant
    Nov 29, 2023 12:54 PM UTC

    No, User type is already a system Administrator!