In this blog post, let’s learn about the error message “9206 You are not authorized to read/write object name. Verify that you have the necessary access privileges.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9206 You are not authorized to read/write object name. Verify that you have the necessary access privileges.
Reason for the Error
NonStop SQL/MX could not perform an UPDATE STATISTICS statement because you are not authorized to perform this operation against this table. You must either own the object name or be the super ID.
Solution
Resubmit after checking the table location and access privileges