How to Revoke Permissions for user/login in MySQL Server
To Revoke permissions of a user account in MySQL Server, below syntax can be used.
Syntax:
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.
Syntax:
MySQL > 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.
MySQL > REVOKE DELETE ON TechBrothers.* FROM 'TB'@'localhost';
MySQL Training for beginners - How to remove permission for MySQL user
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.