How do I revoke privileges

To revoke privileges in MySQL, you can use the REVOKE statement. This allows you to remove specific permissions that were previously granted to a user or a role. The syntax for revoking privileges is as follows:

REVOKE privilege_type ON object_type object_name FROM 'username'@'host';

For example, to revoke the SELECT privilege on a table named customers from a user john connecting from localhost, the command would be:

REVOKE SELECT ON customers FROM 'john'@'localhost';

Make sure to replace privilege_type, object_type, object_name, username, and host with the appropriate values as per your requirement.


mysql revoke privileges mysql user permissions mysql REVOKE statement

Related Questions

How do I avoid rehashing overhead with std::set in multithreaded code?

How do I find elements with custom comparators with std::set for embedded targets?

How do I erase elements while iterating with std::set for embedded targets?

How do I provide stable iteration order with std::unordered_map for large datasets?

How do I reserve capacity ahead of time with std::unordered_map for large datasets?

How do I erase elements while iterating with std::unordered_map in multithreaded code?

How do I provide stable iteration order with std::map for embedded targets?

How do I provide stable iteration order with std::map in multithreaded code?

How do I avoid rehashing overhead with std::map in performance-sensitive code?

How do I merge two containers efficiently with std::map for embedded targets?