0

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.

2
1

[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.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy