In this blog post, let’s learn about the error message “25272 Privileges on type name have been granted to privilege group privilege-group.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25272 Privileges on type name have been granted to privilege group privilege-group.
Reason for the Error
You specified a target version to DOWNGRADE that does not support privilege groups.
Solution
Either use the REVOKE command to remove group privileges on all the schemas and objects that are affected by the DOWNGRADE command or use the DROP PRIVILEGE GROUP command to drop the affected privilege group completely