In this blog post, let’s learn about the error message “1755 Revoke from 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
1755 Revoke from PUBLIC is not allowed.
Reason for the Error
An attempt was made to execute REVOKE CREATE CATALOG or REVOKE CREATE SCHEMA statement with PUBLIC as one of the entries in the grantee list or PUBLIC as the only entry in the grantee list.
Solution
Remove PUBLIC from the grantee list and retry the operation