How many levels that privileges can be granted?

Answer

There are five levels that privileges can be granted.

• Global - Global privileges apply to all databases on a MySQL server. These privileges are stored in the mysql.user table.
• Database - Database privileges apply to all objects of a specified database. These privileges are stored in the mysql.db and mysql.host tables.
• Table - Table privileges apply to all columns in a given table. These privileges are stored in the mysql.tables_priv table. The GRANT ALL ON db_name.table_name and REVOKE ALL ON db_name.table_name commands grant and revoke only table level privileges.
• Column - Column level privileges apply to one or more columns in a given table. These privileges are stored in the mysql.columns_priv table. When using the REVOKE command to remove column level privileges, you must specify the same columns that were granted. The column or columns for which the privileges are to be granted are enclosed within parentheses.
• Routine - The CREATE ROUTINE, ALTER ROUTINE, EXECUTE, and GRANT privileges apply to stored routines (functions and procedures). They can be granted at the global and database levels. Also, except for CREATE ROUTINE, these privileges can be granted at the routine level for individual routines. The privileges are stored in the mysql.procs_priv table.