Learning MySQL by Seyed M.M. Tahaghoghi & Hugh E. Williams

Author:Seyed M.M. Tahaghoghi & Hugh E. Williams [Seyed M.M. Tahaghoghi and Hugh E. Williams]
Language: eng
Format: epub
Tags: COMPUTERS / Database Management / Data Warehousing
ISBN: 9780596105266
Publisher: O'Reilly Media
Published: 2009-06-29T16:00:00+00:00

Privileges

So far, we’ve shown you how to add new users and grant privileges for databases, tables, and columns. In this section, we discuss the privileges in more detail and explain which ones are used at the global, database, table, and column level. Then we discuss how the different privilege levels interact.

You can see a list of all available privileges by running the SHOW PRIVILEGES command in the MySQL monitor; Table 9-1 lists some of the more important of these. Each row shows a privilege, followed by a description, and then a list of the four levels at which the privilege can be granted. For example, the second row shows the ALTER privilege that controls whether the ALTER TABLE statement can be used, and shows that it can be controlled at the global, database, and table levels:

Global level

You can use ON *.* in a GRANT statement to grant a user a particular privilege across all databases on the server.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.