In this blog post, let’s learn about the error message “1754 Grant to PUBLIC is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1754 Grant to PUBLIC is not allowed.
Reason for the Error
An attempt was made by a security administrator to grant a privilege to PUBLIC. A security administrator may not grant a privilege to PUBLIC, unless the security administrator making the grant has been explicitly granted permission to grant the privilege (WITH GRANT OPTION).
Solution
If the target of the grant (PUBLIC) 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
