Skip to main content
November 28, 2023
Question

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

  • November 28, 2023
  • 6 replies
  • 0 views

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
    November 28, 2023

    Is this in a separate DB schema?

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

    November 29, 2023

    No Its in default Cloud Data base

    stefanhelzle0001
    Brainy
    November 29, 2023

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

    karumurua531442
    November 29, 2023

    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

    November 29, 2023

    No, User type is already a system Administrator!