Multiple choice technology databases

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 USER1 allowed to perform?

  1. Drop an index on the EMPLOYEE table

  2. Grant all privileges on the EMPLOYEE table to other users

  3. Alter the table definition

  4. Drop the EMPLOYEE table
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The GRANT ALL PRIVILEGES on table grants table-level privileges including SELECT, INSERT, UPDATE, DELETE, and ALTER. It does NOT grant CONTROL or schema-level privileges needed to drop indexes, tables, or grant privileges to others. Altering the table definition (ALTER privilege) is allowed. Dropping indexes/tables requires higher authority.

Keep practicing — related questions