Database Reference
In-Depth Information
Privilege
Description
CREATE VIEW
The ability to create views.
DELETE
The ability to delete rows from tables.
DROP
The ability to delete entire databases and
tables.
EVENT
The ability to alter, create, and drop
events from the event scheduler.
EXECUTE
The ability to execute stored functions
and procedures.
INDEX
The ability to create or delete indexes.
INSERT
The ability to insert new rows of data into
a table.
LOCK TABLES
The ability to lock and unlock tables.
SELECT
The ability to read data from a table.
SHOW VIEW
The ability to use the
SHOW CREATE
VIEW
statement.
TRIGGER
The ability to use the
CREATE TRIGGER
and
DROP TRIGGER
statements.
UPDATE
The ability to modify rows in a table.
Column privileges apply to individual columns within a table. There are only three
of them:
INSERT
,
UPDATE
, and
SELECT
.
Miscellaneous privileges and limits
The following table lists miscellaneous privileges which don't quite fit into either of
the two previous categories.
Privilege
Description
USAGE
Grants nothing real, but can be used to change
global options for a user.
ALL PRIVILEGES
Can be used to grant all available privileges to a
user. Does not grant the
GRANT
OPTION
privilege.
Can be shortened to
ALL
.
GRANT OPTION
Gives a user the ability to give other users the
privileges they have. This is given at the end of
the
GRANT
statement. See the
Granting Permissions
section of this chapter for some examples.
