I want to know how it is possible to share a database tables between multiple users/user groups, I mean, SQL Server has a security feature that we can create user groups and assign users to them, then we can give each user group permissions for tables in a database/schema. So, a user from visitors usergroup can't read sensitive admin tables, or a visitor can read categories but can't insert/update categories table but users from admin user group can.
Mysql – Sharing Databases and Tables between users in MySQL
MySQLSecurity
Related Question
- Sql-server – Users cannot view tables in non-default schema in SSMS
- MS Access 2007+ – Setting User-Level Security
- MySQL – Allow Multiple Users to Change Functions
- Sql-server – Grant access to all objects (with a few exceptions) to a role
- Mysql – How to implement UNIX like ACL for table rows
- SQL Server – Track Logins from Specific Active Directory Group
- Mysql – How to structure MySQL database tables for users and how to handle adding/removing permissions
Best Answer
[https://mariadb.com/kb/en/mariadb/roles/](MariaDB 10.0.5 has Roles); see if they provide what you desire.
(Yes, MariaDB is essentially compatible with MySQL; Roles is an extra feature.)