In this blog post, let’s learn about the error message “1751 No privileges were granted. User user-name 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
1751 No privileges were granted. User user-name is a security administrator.
Reason for the Error
A security administrator tried to grant privilege to a user, currently designated as a security administrator. A security administrator may not grant a privilege to another security administrator, unless the security administrator granting the privilege has been explicitly granted permission to grant the privilege.
Solution
If the target of the grant (the grantee) is in error, correct the error, and resubmit the GRANT statement. If explicitly granting the privilege WITH GRANT OPTION to the security administrator is appropriate, issue a GRANT statement on the affected object WITH GRANT OPTION by an authorized user such as the object owner, and resubmit the failed GRANT statement
