|
What are the scope levels a user privilege can be granted in MySQL?Below are the scope levels:-
1. Global Level – This privilege applies to ALL databases present. Privileges granted at the global level stored in "mysql.user" table.
2. Database Level - This privilege applies to ALL tables present. Privileges granted at the global level stored in "mysql.db" table.
3. Table Level - This privilege applies to ALL columns present in the tables specifed. Privileges granted at the global level stored in "mysql.tables_priv" table.
4. Column Level - This privilege applies to a specific column of the specified table. Privileges granted at the global level stored in "mysql.columns_priv" table.
5. 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.
|
