In this blog post, let’s learn about the error message “1659 Privilege group pg-name is not empty.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1659 Privilege group pg-name is not empty.
Reason for the Error
You specified the RESTRICT option and attempted DROP PRIVILEGE GROUP on a privilege group with one or more members. RESTRICT is the default if neither RESTRICT nor CASCADE is specified.
Solution
Use the CASCADE option to drop a non-empty privilege group
