How Many Scope Levels Can User Privileges Apply in MySQL?

MySQL supports 5 scope levels a user privilege can be granted:

• Global Level - A privilege granted at this level applies to all databases on the server. Privileges granted at the global level stored in "mysql.user" table.
• Database Level - A privilege granted at this level applies to all tables in the specified database. Privileges granted at the global level stored in "mysql.db" table.
• Table Level - A privilege granted at this level applies to all columns in the specified table. Privileges granted at the global level stored in "mysql.tables_priv" table.
• Column Level - A privilege granted at this level applies to only the specified column. Privileges granted at the global level stored in "mysql.columns_priv" table.
• Routine Level - A privilege granted at this level applies to only the specified stored function procedure. Privileges granted at the global level stored in "mysql.procs_priv" table.

⇒ Giving Privileges at Server Level in MySQL

⇐ What Are User Privileges in MySQL

⇑ Managing User Accounts and Access Privileges in MySQL

⇑⇑ MySQL Database Tutorials