HPE NonStop SQL/MX Error – 21137 User user-name has privileges on the database objects granted explicitly by other users of the database database-name.

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