4.26

Explain the difference between integrity constraints and authorization constraints.


Integrity constraints ensure that changes made to the database by authorized users do not result in a loss of data consistency. That is, they guard us against accidental damage to the database.
Example: * Domain constriants * Unique constraints * Referential Integrity constraints

Authorization constraints guard against access to the database by unauthorized users.
Example: * Authorization to read data * Authorization to insert new data * Authorization to delete data