How Many Scope Levels Can User Privileges Apply

Q

How Many Scope Levels Can User Privileges Apply? - MySQL FAQs - Managing User Accounts and Access Privileges

✍: FYIcenter.com

A

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.

2007-05-10, 4356👍, 0💬