In this blog post, let’s learn about the error message “1672 Privilege group grantees and distributed catalogs are not compatible.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1672 Privilege group grantees and distributed catalogs are not compatible.
Reason for the Error
You attempted to:
Grant privileges to a privilege group on an object or schema in a distributed catalog.
Register a catalog where privileges on objects or schemas are granted to a privilege group.
Solution
In a distributed environment, grant privileges only to individual users