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
Nice Tutorials
ReplyDeleteLiên hệ Aivivu, đặt vé máy bay tham khảo
ReplyDeletevé máy bay đi Mỹ giá rẻ
vé máy bay từ hải phòng về sài gòn
vé máy bay cần thơ hà nội bao nhiêu
vé máy bay hà nội nha trang giá rẻ
ve may bay di Hue re nhat
dịch vụ taxi sân bay
combo khách sạn đà nẵng