What does the following statement do?
GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION
A.
Gives USER1 the ability to change the comment associated with a sequence named
GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other
users and groups.
B.
Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and
NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the
ability to give CONTROL authority for the sequence to other users and groups.
C.
Gives USER1 the ability to change the comment associated with a sequence named
GEN_EMPID, along with the ability to give this authority to other users and groups.
D.
Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and
NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the
ability to give this authority to other users and groups.
The ALTER SEQUENCE statement can be used to change a sequence in any of these ways:
Restarting the sequence
Changing the increment between future sequence values
Setting or eliminating the minimum or maximum values
Changing the number of cached sequence numbers
Changing the attribute that determines whether the sequence can cycle or not
Changing whether sequence numbers must be generated in order of request
0
0
COMMENT
The COMMENT statement adds or replaces comments in the descriptions of various objects in the DB2® catalog at the current server.
Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Authorization
For a comment on the following objects, the privilege set must include at least one of the listed authorities or privileges:
Sequence:
Ownership of the sequence
The ALTER privilege for the sequence
The ALTERIN privilege on the schema
SYSADM or SYSCTRL authority
System DBADM
The authorization ID that matches the schema name implicitly has the ALTERIN privilege on the schema.
0
0