An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow
user USER1 to drop the EMPID_X index?
A.
GRANT DROP ON INDEXempid_x TO user1
B.
GRANT DELETE ON INDEXempid_x TO user1
C.
GRANT INDEX ON TABLE employee TO user1
D.
GRANT CONTROL ON INDEXempid_x TO user1
To grant privileges on database objects,
you must have ACCESSCTRL , SECADM , or CONTROL privilege on that object.
0
0
CONTROL Table, View, Index, Package, Alias, Distinct
Type, User Defined function, Sequence
Provides full authority on the object. Users
with this privilege can also grant or revoke
privileges on the object to other users.
0
0