HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Error Messages (Cont.)
2311 MESSAGE Group ! not found. (DBERR 2311)
CAUSE The group name specified in the DROP GROUP, ADD TO
GROUP, or REMOVE FROM GROUP statement, does not
exist in the DBEnvironment.
ACTION Check your spelling. If you still receive this
error, ask your database administrator to check the
SYSTEM.GROUP view to determine if the group exists
in the DBEnvironment.
----------------------------------------------------------------------------
2312 MESSAGE User or group ! already exists. (DBERR 2312)
CAUSE The user or group name specified in the
CREATE GROUP statement already exists in the
DBEnvironment.
ACTION Issue the command again, specifying a unique user
or group name.
----------------------------------------------------------------------------
2313 MESSAGE User ! not found in group !. (DBERR 2313)
CAUSE The DBEUserID specified in the REMOVE FROM GROUP
statement does not exist in the specified group.
ACTION Check your spelling. If you still receive this
error, ask your database administrator to check the
SYSTEM.GROUP view to make sure that the specified
user does exist in the group.
----------------------------------------------------------------------------
2314 MESSAGE User ! already a member of group !. (DBERR 2314)
CAUSE The DBEUserID in the ADD command is already a
member of the group.
ACTION No action is necessary.
----------------------------------------------------------------------------
2315 MESSAGE User or group ! conflicts with existing !.
(DBERR 2315)
CAUSE The group name specified in the CREATE GROUP
statement is already being used as a DBEUserID or
group name in the manner specified in the second
parameter; or a CONNECT was attempted with a
DBEUserID equivalent to an existing group name.
ACTION Remove the existing usage before re-issuing the
CREATE GROUP, or issue it with a different group
name; or drop the group to permit the connection;
or do not attempt to CONNECT with that DBEUserID.
----------------------------------------------------------------------------
2316 MESSAGE User or group ! owns object(s) in the
DBEnvironment. (DBERR 2316)
CAUSE The DBEUserID or group specified in the DROP
command is the owner name of either tables, views,
modules, or groups in the DBEnvironment.
ACTION Drop the objects or transfer ownership to another
DBEUserID or group before dropping the user or
group.
----------------------------------------------------------------------------
2317 MESSAGE User or group ! is (indirect) member of group !.
(DBERR 2317)
CAUSE You tried to add a group (or user) to a group which
is already a member of the group you tried to add.
ACTION No action is necessary. If you specified more than
one user or group in the ADD TO GROUP statement,
the valid names were processed and the invalid
names were ignored.
----------------------------------------------------------------------------
2318 MESSAGE Cannot add group ! to itself. (DBERR 2318)
CAUSE You tried to add a group (or user) to itself.
ACTION Issue the command again, specifying a set of unique
group or user names which does not include the
target group name.
----------------------------------------------------------------------------
2319 MESSAGE Cannot remove group ! from itself. (DBERR 2319)
CAUSE You tried to remove a group from itself.
ACTION Issue the command again, specifying a set of group
names which does not include the target group name.
----------------------------------------------------------------------------
2321 MESSAGE CONNECT disallowed. Group ! already exists.
(DBERR 2321)
CAUSE A group name that is the same as your DBEUserID
name exists in the DBEnvironment.
ACTION Sign on as a different user. Ask your database
administrator to change the group name to something
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 doing so would not cause a
cycle).
----------------------------------------------------------------------------
2327 MESSAGE GRANT of ! authority to ! on !.!.! causes a
cycle. (DBERR 2327)
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 doing so would not cause a
cycle).
----------------------------------------------------------------------------
2328 MESSAGE User ! does not have direct OWNER, DBA, or
GRANTABLE ! authority on !.!. (DBERR 2328)
CAUSE Attempted to GRANT the specified authority WITH
GRANT OPTION, but did not have the direct authority
needed to do so.
ACTION To grant WITH GRANT OPTION, the user must be
authorized to grant directly, not through group
membership. Have the system administrator or table
owner grant you the authority with the grant option
directly, or perform the grant you wish done.
----------------------------------------------------------------------------
2329 MESSAGE User ! does not have direct OWNER, DBA, or
GRANTABLE ! authority on !.!.!. (DBERR 2329)
CAUSE Attempted to GRANT the specified authority WITH
GRANT OPTION, but did not have the direct authority
needed to do so.
ACTION To grant WITH GRANT OPTION, the user must be
authorized to grant directly, not through group
membership. Have the system administrator or table
owner grant you the authority with the grant option
directly, or perform the grant you wish done.
----------------------------------------------------------------------------
2330 MESSAGE Group ! not allowed to grant privileges. (DBERR
2330)
CAUSE Between the time the GRANT was compiled and
executed, the user performing the GRANT became a
group. GRANTs cannot be performed by groups, due
to the need to store the user name of the grantor.
ACTION Drop the group or re-perform the GRANT with a valid
user name.
----------------------------------------------------------------------------
2331 MESSAGE Group ! cannot be granted privileges WITH GRANT
OPTION. (DBERR 2331)
CAUSE You attempted to grant WITH GRANT OPTION to a
group.
ACTION Repeat the grant without the specified group, or
without WITH GRANT OPTION.
----------------------------------------------------------------------------
2332 MESSAGE User not authorized to revoke ! on !.! from
user/group !. (DBERR 2332)
CAUSE You are not the OWNER, DBA, or grantor of the
specified privilege on the specified table to the
specified user/group.
ACTION Have the system administrator determine the grantor
of the privilege and have that person perform the
revoke, or have the table owner or a DBA perform
the revoke.
----------------------------------------------------------------------------
2333 MESSAGE User not authorized to revoke ! on !.!.! from
user !. (DBERR 2333)
CAUSE You are not the OWNER, DBA, or grantor of the
specified privilege on the specified column to the
specified user/group.
ACTION Have the system administrator determine the grantor
of the privilege and have that person perform the
revoke, or have the table owner or a DBA perform
the revoke.
----------------------------------------------------------------------------
2334 MESSAGE GRANT/REVOKE of ALTER/INDEX/REFERENCES authority
not allowed on a view (!.!). (DBERR 2334)
CAUSE You attempted to GRANT or REVOKE one of the
privileges ALTER, INDEX, or REFERENCES on the
specified view.
ACTION Repeat the command without any of the privileges
listed above.
----------------------------------------------------------------------------
2335 MESSAGE User ! already has ! authorization on !.! with a
different grantability. (DBERR 2335)
CAUSE You attempted to re-grant an authority with a
different grantability (WITH GRANT OPTION was
specified on only one of the grants).
ACTION Re-issue the grant without the specified
authorization, or revoke the specified
authorization and then reissue the grant.
----------------------------------------------------------------------------
2336 MESSAGE User ! already has ! authorization on !.!.! with
a different grantability. (DBERR 2336)
CAUSE You attempted to re-grant an authority with a
different grantability (WITH GRANT OPTION was
specified on only one of the grants).
ACTION Re-issue the grant without the specified
authorization, or revoke the specified
authorization and then reissue the grant.
----------------------------------------------------------------------------
2337 MESSAGE User ! already has ! authorization on columns of
!.! with a different grantability. (DBERR 2337)
CAUSE You attempted to grant a table level authority with
a different grantability from an existing column
level authority which this would override (WITH
GRANT OPTION was specified on only one of the
grants).
ACTION Re-issue the grant without the specified
authorization, or revoke the specified
authorization and then reissue the grant.
----------------------------------------------------------------------------
2338 MESSAGE User ! does not have OWNER, DBA, or direct
GRANTABLE ! authority on !.!. (DBERR 2338)
CAUSE You attempted to perform a GRANT WITH GRANT OPTION
or REVOKE of the specified authority without having
the authority to do so.
ACTION You need to have OWNER, DBA, or have been granted
the authority WITH GRANT OPTION in order to perform
a GRANT WITH GRANT OPTION or REVOKE of the
authority.
----------------------------------------------------------------------------
2339 MESSAGE User ! does not have OWNER, DBA, or direct
GRANTABLE ! authority on !.!.!. (DBERR 2339)
CAUSE You attempted to perform a GRANT WITH GRANT OPTION
or REVOKE of the specified authority without having
the authority to do so.
ACTION You need to have OWNER, DBA, or have been granted
the authority WITH GRANT OPTION in order to perform
a GRANT WITH GRANT OPTION or REVOKE of the
authority.
----------------------------------------------------------------------------