Privileges
The privileges that can be granted to the users are listed below along with description:
SELECT
- Select statement on tablesINSERT
- Insert statement on the tableDELETE
- Delete statement on the tableINDEX
- Create an index on an existing tableCREATE
- Create table statementsALTER
- Ability to perform ALTER TABLE to change the table definitionDROP
- Drop table statementsUPDATE
- Update statements on the tableALL
- Grant all permissions except GRANT OPTIONGRANT
-Allows to grant the privilege that