MariaDB > GRANT SELECT ON testdb.* TO flush privileges for the changes to take effect. To grant a specific user permission, use the syntax: MariaDB > GRANT permission_type ON database_name.table_name TO you can assign permissions to all the tables in a database with a single asterisk symbol as shown: MariaDB > GRANT permission_type ON database_name.* TO example, to assign SELECT permissions to ‘ tecmint‘ user on all tables of the database testdb, run the command. GRANT OPTION – Users can grant or remove the privileges of other users.UPDATE – Allows users to updates the rows in a table.SELECT – with ‘SELECT’ permission, users are able to read the contents of a table.DELETE – Allows users to delete rows from tables.INSERT – Allows users to insert rows in tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |