Privileges

The privileges that can be granted to the users are listed below along with description:

  • SELECT - Select statement on tables
  • INSERT - Insert statement on the table
  • DELETE - Delete statement on the table
  • INDEX - Create an index on an existing table
  • CREATE - Create table statements
  • ALTER - Ability to perform ALTER TABLE to change the table definition
  • DROP - Drop table statements
  • UPDATE - Update statements on the table
  • ALL - Grant all permissions except GRANT OPTION
  • GRANT -Allows to grant the privilege that