In this blog post, let’s learn about the error message “1758 Request failed. Operation cannot be performed because targeted new owner does not have sufficient privileges on object-type object-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1758 Request failed. Operation cannot be performed because targeted new owner does not have sufficient privileges on object-type object-name.
Reason for the Error
You attempted a GIVE operation on a table or view with a dependent view or table.
Solution
For a GIVE VIEW operation, ensure that sufficient privileges are granted to the new view owner and resubmit the statement.
For a GIVE TABLE operation, if the existing table owner and view owner are the same, ensure that the table owner grants all the privileges on the table to itself and resubmit the statement
