ALLBASE/SQL Message Manual (36216-90213)

Chapter 5 157
ALLBASE/SQL Error Messages: 2101-2419
different from your DBEUserid name so that this problem
will not occur in the future.
2322 MESSAGE User ! already has ! authorization on !.!
from a different grantor. (DBERR 2322)
CAUSE Attempted to GRANT the specified authority to a user who
has the authority from another grantor already, and you
would not be able to revoke that authority.
ACTION Repeat the GRANT without that user and/or
authorization.
2323 MESSAGE User ! already has ! authorization on !.!.!
from a different grantor. (DBERR 2323)
CAUSE Attempted to GRANT the specified authority to a user who
has the authority from another grantor already, and you
would not be able to revoke that authority.
ACTION Repeat the GRANT without that user and/or
authorization.
2324 MESSAGE Cannot revoke ! authorization from ! on !.!
without CASCADE. (DBERR 2324)
CAUSE Attempted to REVOKE the specified authority from a user
who has used the grantability of that authority to grant to
another user.
ACTION Use REVOKE CASCADE if you wish to remove all the
grants that user has cascaded on the authority, or get a
DBA to perform the revoke on that user (this will leave all
of that user's grants intact). The DBA should use the BY
option of the REVOKE statement to avoid an orphaned
privilege.
2325 MESSAGE Cannot revoke ! authorization from user ! on
!.!.! without CASCADE. (DBERR 2325)
CAUSE Attempted to REVOKE the specified authority from a user
who has used the grantability of that authority to grant to
another user.
ACTION Use REVOKE CASCADE if you wish to remove all the
grants that user has cascaded on the authority, or get a
DBA to perform the revoke on that user (this will leave all
of that user's grants intact).
2326 MESSAGE GRANT of ! authority to ! on !.! causes a
cycle. (DBERR 2326)
CAUSE Attempted to GRANT the specified authority which would
cause a cycle of grants in the authority list.
ACTION Examine the chain of grants to determine if the cycle can
be broken, or have someone else perform the grant (if their