SQL/MX 3.1 Messages Manual (H06.23+, J06.12+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
3-78
Cause. The NOT NULL constraint cannot be created on a referencing column with the
SET NULL referential action on it. (OR) The primary key constraint cannot be created
on the referencing column with the referential action specified because the primary key
cannot be updated.
Effect. The operation fails.
Recovery. Drop the referential integrity constraint.
SQL 1750
Cause. A security administrator attempted to execute a GRANT statement for a
privilege using WITH GRANT OPTION for which that security administrator had not
explicitly been granted the privilege WITH GRANT OPTION.
Effect. The operation fails.
Recovery. Resubmit the command without the WITH GRANT OPTION.
SQL 1751
Where user-name is the grantee for the privilege.
Cause. 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.
Effect. The operation fails.
Recovery. If the target of the grant (the grantee) 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 1752
Where user is the user name or user id.
1750 WITH GRANT OPTION not allowed for security
administrators.
1751 No privileges were granted. User user-name is a security
administrator.
1752 User user is not a security administrator.