Categories

Updated: 11/09/1999

The MySQL Grant Tables

One of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each user''s intended behavior. This control can restrict user privileges over a general part of the server, such as limited access to an entire database, but can also be as specific as limiting privileges for a specific table or even column. This article will serve to explain the process in which the MySQL server grants/revokes these user privileges, highlighting in particular the newest additions to the MySQL privilege system, the tables_priv and columns_priv tables. Please keep in mind that the GRANT/REVOKE commands detailed later in this article are only relevant to MySQL version 3.22.11 and up.
©2003-2019 jCay.com