In this blog post, let’s learn about the error message “1014 Privileges were not revoked. Dependent privilege descriptors still exist.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1014 Privileges were not revoked. Dependent privilege descriptors still exist.
Reason for the Error
You attempted to revoke a privilege for a user who has granted privileges to another user. Privileges must be revoked in reverse order from how they were granted. If you perform a grant to another user who, then performs a grant to a third user, you cannot revoke privileges from the second user until that user revokes privileges from the third user.
Solution
Ensure that the dependent privileges are first revoked from the user whose privileges you want to revoke
