In this blog post, let’s learn about the error message “21137 User user-name has privileges on the database objects granted explicitly by other users of the database database-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
21137 User user-name has privileges on the database objects granted explicitly by other users of the database database-name.
Reason for the Error
There are privileges granted to the user by other users of the database.
Solution
Before removing the user from the database, revoke all explicitly granted privileges from the user and retry the mxdbs operation
