SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-4
SQL 1013
Cause. You attempted to grant privileges, but you do not have grant options for at
least one of them.
Effect. SQL/MX granted some privileges, but not all that you attempted to grant.
Recovery. You must have grant options for privileges to grant them.
SQL 1014
Cause. You attempted to revoke a privilege for a user who has granted privileges to
another user. Privileges must be revoked in reverse order from how they were granted.
If you perform a grant to another user who then performs a grant to a third user, you
cannot revoke privileges to the second user until that user revokes their privileges to
the third user.
Effect. SQL/MX did not revoke the privileges.
Recovery. Make sure that the dependent privileges from the user whose privileges
you want to revoke are revoked first.
SQL 1015
Cause. You attempted to revoke a privilege that does not exist or that was granted by
another user.
Effect. SQL/MX did not revoke the privileges.
Recovery. The user who granted the privileges must revoke them.
SQL 1016
Where column-name is an SQL identifier.
Cause. You created a constraint with multiple references to column-name.
Effect. The operation fails.
1013 Not all privileges were granted. You lack grant option
on some of the specified privileges.
1014 Privileges were not revoked. Dependent privilege
descriptors still exist.
1015 Some of the specified privileges could not be revoked.
1016 Redundant references to column column-name were
specified in the constraint or trigger definition.