The Following are the MySQL Database Structure Privileges These are usually reserved for designers and Administrators
CREATE VIEW: Create a View
ALTER: Change the Structure of a Table
CREATE ROUTINE: Create a Stored Procedure or Function
DROP: Delete a Database or Table
CREATE: Create a Database or a Table
CREATE INDEX: Create or Drop an Index
ALTER ROUTINE: Change or Delete a Stored Procedure or Function
TRIGGER: Change or Delete a Trigger on a Table
EVENT: Do anything with a Database event