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, 5257👍, 0💬
Related Topics:
