How to Grant Insert Permission on Table/s to a User in MariaDB
Below Syntax can be used to provide INSERT permission on table/s in MariaDB.Syntax:
On Single Table
MariaDB > GRANT INSERT ON tableName to 'UserName'@'Host'
On all the tables in a database
MariaDB > GRANT INSERT ON DatabaseName.* to 'UserName'@'Host'
Example :
Let's say that if we have table "test" in Techbrothers Database and we would like to provide INSERT permission to user "Aamir" in MariaDB. we can use below statement
MariaDB > GRANT INSERT ON Techbrothers.test to 'Aamir'@'localhost'
If we would like to provide INSERT permission on all the tables in Techbrothers Database to user account Aamir in MariaDB, we can use below statement
MariaDB > GRANT INSERT ON Techbrothers.* to 'Aamir'@'localhost'
Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế
ReplyDeletegiá vé máy bay đi Mỹ khứ hồi
vé máy bay đi từ vinh vào sài gòn
vé máy bay từ chu lai đi hà nội
ve may bay gia re di Hue
vé máy bay khứ hồi đi quy nhơn
taxi đi sân bay nội bài
I think you can choose the better options that are related to this, it will be helpful for everyone. For more details check out online spacebar counter 10
ReplyDelete