After the following SQL statement is executed:
GRANT ALL PRIVILEGES ON TABLE employee TO USER user1
Assuming user USER1 has no other authorities or privileges, which of the following actions is user
USER1 allowed to perform?
A.
Drop an index on the EMPLOYEE table
B.
Grant all privileges on the EMPLOYEE table to other users
C.
Alter the table definition
D.
Drop the EMPLOYEE table
CONTROL Grants ALL of the appropriate privileges in the list:
ALTER, CONTROL, DELETE, INSERT, INDEX, REFERENCES, SELECT, and UPDATE to base tables
0
0
ALL or ALL PRIVILEGES
Grants all the appropriate privileges, except CONTROL, on the base table, view, or nickname named in the ON clause.
If the authorization ID of the statement has CONTROL privilege on the table, view, or nickname, or ACCESSCTRL or SECADM authority, then all the privileges applicable to the object (except CONTROL) are granted. Otherwise, the privileges granted are all those grantable privileges that the authorization ID of the statement has on the identified table, view, or nickname.
If ALL is not specified, one or more of the keywords in the list of privileges must be specified.
0
0