Data Security and the DBMS

Another important role of a Database Management System (DBMS) is to enforce data security.

Based on the assigned roles of users, a DBMS system can ensure that a given user only has read and/or update access to appropriate columns in the database.

This approach can make sure that private data, such as salary information, is only accessible to the appropriate parties.

Data access can be restricted via database "views" that filter out sensitive data and by other means.