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.
-
You should read the mysql manual on access priviele system and user account management first and then ask specific question if sg is still unclear: dev.mysql.com/doc/refman/5.7/en/privilege-system.html dev.mysql.com/doc/refman/5.7/en/user-account-management.html– ShadowCommented Jan 26, 2016 at 14:58
-
Btw, in mysql there are no groups or roles, only users.– ShadowCommented Jan 26, 2016 at 14:59
Add a comment
|
1 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.)
answered Jan 27, 2016 at 1:41
