SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-81
Cause. An attempt was made to revoke the security administrator designation from a
user name or user id specified by user which had not previously been designated as
a security administrator.
Effect. The operation fails.
Recovery. Reissue the command, specifying a current security administrator.
SQL 1753
Cause. An attempt was made by super.super to grant or revoke privileges while the set
of security administrators was not empty, super.super was not designated as a security
administrator, and super.super did not explicitly have the privilege to grant or revoke
the privileges in question.
Effect. The operation fails.
Recovery. Designate super.super as a security administrator or explicitly grant the
necessary privileges to super.super, and run the command again.
SQL 1754
Cause. 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).
Effect. The operation fails.
Recovery. If the target of the grant (PUBLIC) is in error, correct the error, and resubmit
the GRANT statement. If it is appropriate to explicitly grant the privilege WITH GRANT
OPTION to the security administrator, 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.
SQL 1755
Cause. 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.
Effect. The operation fails.
1753 You must be a security administrator to perform this
operation.
1754 Grant to PUBLIC is not allowed.
1755 Revoke from PUBLIC is not allowed.