SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
3-83
SQL 1752
Where user is the user name or user id.
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.
1752 User user is not a security administrator.
1753 You must be a security administrator to perform this
operation.
1754 Grant to PUBLIC is not allowed.