How to use REVOKE statement in MariaDB

How to use REVOKE statement in MariaDB

To Revoke permissions of a user account in MariaDB below syntax can be used.

Syntax:
MariaDB > REVOKE PermissionType ON Object To 'UserName'@'Host';

Example: 
Let's say we have user TB and we have provided Delete Permission on all the Tables in TechBrothers Database and we would like to Revoke.We can use below statement.
MariaDB > REVOKE DELETE ON TechBrothers.* FROM 'TB'@'localhost';

1 comment: