In this blog post, let’s learn about the error message “1771 Request failed. Operation cannot be performed because the owner of object-1 would lose required privileges on object-2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1771 Request failed. Operation cannot be performed because the owner of object-1 would lose required privileges on object-2.
Reason for the Error
You attempted to change ownership of a schema, view, or table. As a result, the view owner of object-1 loses SELECT privilege on object-2. It is required that a view owner has select privilege on all objects used by the view, or on their schemas.
Solution
Grant the required privileges directly on the used objects and then retry the GIVE command
