In this blog post, let’s learn about the error message “1664 No privileges were granted. Privilege group pg-name has member user-name who is a security administrator.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1664 No privileges were granted. Privilege group pg-name has member user-name who is a security administrator.
Reason for the Error
A security administrator tried to grant a privilege to a privilege group that has a designated security administrator as member, this is not permitted.
Solution
Specify the correct privilege group name or remove the incorrect user from the privilege group and retry the grant operation