Security is vital to a database. Database administrators need to protect confidential and sensitive data and guard against accidental and inadvertent edits of data. R:BASE's optimistic concurrency control, table and row locking, constraints (primary and foreign keys), and data entry and delete rules provide a wide variety of data integrity controls. In addition, R:BASE has the following two options for controlling access to your data. The two options are:
•SQL Grant/Revoke system of access rights
•Form read and modify passwords
Each option provides a different type and level of security. Understanding and using these options enables application developers to provide appropriate security for any type of database and application.