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.