In this blog post, let’s learn about the error message “11063 The owner of trigger trigger-name must be the same as the owner of its subject table table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11063 The owner of trigger trigger-name must be the same as the owner of its subject table table-name.
Reason for the Error
You attempted to create a trigger, or to change the ownership of a schema, or a trigger, in a way that would cause the trigger and its subject table to be owned by different users. That is not permitted.
Solution
For trigger creation: Create the trigger in a way that would cause it to have the same owner as its subject table. For example, create it in the same schema as the subject table.
For schema ownership change: Explicitly change the ownership of the trigger subject table before changing schema ownership.
For trigger ownership change: You cannot change ownership of a trigger directly
