User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements
is user USER1 allowed to execute?
A.
GRANT CONTROL ON table1 TO user2
B.
GRANT LOAD ON table1 TO user2
C.
GRANT INSERT,UPDATE ON table1 TO user2 WITH GRANT OPTION
D.
GRANT BINDADD ON table1 TO PUBLIC
E.
GRANT ALL PRIVILEGES ON table1 TO PUBLIC
CONTROL Grants All of the appropriate privileges in the list:
ALTER, CONTROL, DELETE, INSERT, INDEX, REFERENCES, SELECT, and UPDATE to base tables
CONTROL, DELETE, INSERT, SELECT, and UPDATE to views.
ALTER, CONTROL, INDEX, and REFERENCES to nicknames.
The ability to grant the above privileges (except for CONTROL) to others.
The ability to drop the base table, view, or nickname.
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