Short answer...... SQL Server for example..... If you have many users you create GROUPS.

You modify each Group to have Read Only or Read/Write or Full blown Admin Level access.

You can adjust different sections of the database for each group as needed.