 DBMS.ca |
Data SecurityA Guide to Database Management Systems |
Another important role of a Database Management System 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 ensure 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.