First page Back Continue Last page Image

Structure Privileges can you Grant to Users?

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