Removing Permissions from a Database : REVOKE « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. REVOKE
SELECT db.User, db.Host, db.Db
FROM db
WHERE (db.Db LIKE 'test%');

DELETE FROM db
WHERE (db.Db LIKE 'test%');








27.6.REVOKE
27.6.1.Revoking privileges
27.6.2.To remove UPDATE, INSERT and DELETE privileges
27.6.3.Removing Permissions from a Database
27.6.4.No other database can allow any user to connect from any host.
27.6.5.Removing Permissions from a User