To alter a table's schema (such as changing data types or properties), a user typically needs to be the owner of the table or have ALL PRIVILEGES. The MODIFY privilege only allows inserting, updating, and deleting data, not altering the table's structure.