What Are User Privileges

Q

What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges

✍: FYIcenter.com

A

MySQL offers many user privileges to control user accesses to different funtions and data objects. Here are some commonly used privileges:

  • ALL - All privileges.
  • CREATE - Allows the user to use CREATE TABLE commands.
  • ALTER - Allows the user to use ALTER TABLE commands.
  • DROP - Allows the user to use DROP TABLE commands.
  • DELETE - Allows the user to use DELETE commands.
  • INSERT - Allows the user to use INSERT commands.
  • UPDATE - Allows the user to use UPDATE commands.
  • SELECT - Allows the user to use SELECT commands.
  • SHUTDOWN - Allows the user to use "mysqladmin shutdown".
  • INDEX - Allows the user to create and drop indexes.
  • CREATE USER - Allows the user to manage user accounts.
  • CREATE VIEW - Allows the user to user "CREATE VIEW" commands.
  • USAGE - No privileges.

2007-05-10, 4827👍, 0💬