Unlike the dynamic privileges that get defined at runtime, the static privileges are built within the server itself. The following are some of the static privileges available in MySQL and explanations thereof:
- ALL, or ALL PRIVILEGES: This privilege is a shorthand specifier. If we consider any privilege level, this specifier would refer to all the privileges that are present in the considered level.
Here is an example. If we grant ALL privileges for table-level or even global-level access, it indicates that the grants are applied to all global or all table-level privileges.
Maybe, on occasion, you need to give a user named (user_read) just the ability to read data (SELECT) from the table (teachers) of the database (school), rather than providing all privileges to the database as a whole. You can accomplish this by doing the...
