How to Grant Delete Permission on Table/s to a User in MariaDB
Below Syntax can be used to provide DELETE permission on table/s in MariaDB.Syntax:
On Single Table
MariaDB > GRANT DELETE ON tableName to 'UserName'@'Host'
On all the tables in a database
MariaDB > GRANT DELETE ON DatabaseName.* to 'UserName'@'Host'
Example :
Let's say that if we have table "test" in Techbrothers Database and we would like to provide DELETE permission to user "Aamir" in MariaDB. we can use below statement
MariaDB > GRANT DELETE ON Techbrothers.test to 'Aamir'@'localhost'
If we would like to provide DELETE permission on all the tables in Techbrothers Database to user account Aamir in MariaDB, we can use below statement
MariaDB > GRANT DELETE ON Techbrothers.* to 'Aamir'@'localhost'
Mua vé máy bay tại Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ
mua vé máy bay từ mỹ về việt nam
bay từ đức về việt nam mấy tiếng
giá vé máy bay nga về việt nam
vé máy bay từ anh về việt nam
chuyến bay từ Paris về Hà Nội
khách sạn cách ly nha trang