MySQL Admin - What Are User Privileges
Interview Question Database For Software Developers
|
|
| What Are User Privileges | | What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges | | By: FYIcenter.com | 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.
| | ID: 965 | Rank: 1096 | Votes: 0 | Views: 66 | Submitted: 20070510 |
1096
:-) | | What Are User Privileges | | What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges... | | Submitted: 20070510 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view