In this blog post, let’s learn about the error message “QL 16711671 This operation cannot be performed because privilege group pg-name is associated with database db-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
QL 16711671 This operation cannot be performed because privilege group pg-name is associated with database db-name.
Reason for the Error
An ALTER PRIVILEGE GROUP, GIVE PRIVILEGE GROUP, or DROP PRIVILEGE GROUP command is specified for a privilege group that is associated with a tenant database, and the session is not connected to that database.
Solution
If the offending privilege group name is in error, correct the name and retry the operation. To alter or drop the privilege group, execute the command when connected to the associated tenant database
