GRANT

GRANT

GRANT privilege_type [(field_list)] [, privilege_type [(field_list)]  ...] ON {table_name | * | *.* | database_name.*} TO user_name  [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY  'password'] ...] [REQUIRE NONE | [{SSL| X509}] [CIPHER cipher [AND]]  [ISSUER issuer [AND]] [SUBJECT subject]] [WITH [GRANT OPTION |  MAX_QUERIES_PER_HOUR # | MAX_UPDATES_PER_HOUR # |  MAX_CONNECTIONS_PER_HOUR #]]

GRANT gives a privilege of a particular kind of permission to a user. Table A.1 describes the available privileges.

Table A.1: Privileges

Privilege

Description

ALL

Grants all the basic permissions.

ALL PRIVILEGES

Same as ALL.

ALTER

Permission to change the structure of a table (an ALTER statement), excluding indexes.

CREATE

Permission to create databases and tables, excluding indexes.

CREATE TEMPORARY TABLES

Permission to create a temporary table.

DELETE

Permission to remove records from a table (a DELETE statement).

DROP

Permission to drop databases or tables, excluding indexes.

EXECUTE

Permission to run stored procedures (scheduled for MySQL 5).

FILE

Permission to read and write files on the server (for LOAD DATA INFILE or SELECT INTO OUTFILE statements). Any files that the mysql user can read are readable.

INDEX

Permission to create, modify, or drop indexes.

INSERT

Permission to add new records to the table (an INSERT statement).

LOCK TABLES

Permission to lock a table for which the user has SELECT permission.

PROCESS

Permission to view the current MySQL processes or kill MySQL processes (for SHOW PROCESSLIST or KILL SQL statements).

REFERENCES

Not currently used by MySQL and provided for ANSI SQL compatibility (it applies to the use of foreign keys).

RELOAD

Permission to reload the database (a FLUSH statement or a reload, refresh, or flush issued from mysqladmin).

REPLICATION CLIENT

Permission to ask about the replication slaves and masters.

SHOW DATABASES

Permission to see all databases.

SELECT

Permission to return data from a table (a SELECT statement).

SHUTDOWN

Permission to shut down the server.

SUPER

Permission to connect even if the maximum number of connections is reached and perform the CHANGE MASTER, KILL thread, mysqladmin debug, PURGE MASTER LOGS, and SET GLOBAL commands.

UPDATE

Permission to modify data in a table (an UPDATE statement).

USAGE

Permission to connect to the server and perform statements available to all (for early versions of MySQL 4 this included SHOW DATABASES).



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net