In this blog post, let’s learn about the error message “21136 Database database-name has privileges granted to one or more grantee of other databases.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
21136 Database database-name has privileges granted to one or more grantee of other databases.
Reason for the Error
You are attempting to unshare a database but one or more users/privilege groups of other databases have been granted privileges on objects in the shared database.
Solution
Revoke all the privileges granted to the users/privilege groups of other database before unsharing the database