You are currently reviewing an older revision of this page.
The following is observed in the application server log:
ERROR liquibase.changelog.ChangeSet - Change Set db-changelog-000168-api-key-table.xml::000168.1.2::appian failed. Error: REFERENCES command denied to user '<user>'@'<host>' for table '<schema>.<table>' [Failed SQL: ALTER TABLE <schema>.api_key ADD CONSTRAINT api_key_usrid_fk FOREIGN KEY (usr_id) REFERENCES <schema>.<table> (id)
The REFERENCES permission might have changed due to a possible database upgrade (application version upgrade).
REFERENCES
GRANT REFERENCES ON <schema>.<table> TO '<user>'@'<host>';
This article applies to all versions of Appian.