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';
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.