- 1,251 categories
- 40,829 scripts
Updated: 11/09/1999
- 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.
- Categories
- Platforms
- Licenses