In a DBMS, what does security mean? What does authorization mean? Why are they required? Is authorization a type of security mechanism? What are the other security mechanisms implemented?
Security is the process of preventing any intentional or accidental loss of data and any malicious entry of intruders. Authorization is the granting of access or privileges to a user after identifying or getting the user authenticated. Yes, it is a type of security mechanism. In layman terms, it is called as user access control. It basically controls what data the user can access and modify. The other security mechanisms implemented are authentication of the user, Data encryption, etc.
