New insights into database security: An effective and integrated approach for applying access control mechanisms and cryptographic concepts in Microsoft Access environments

The current database security literature provides a comprehensive coverage about access control mechanisms and users privileges specifically in SQL; however, it does not present anything about Microsoft Access and which access control techniques to use. Therefore, this paper will address two weaknesses: first, user’s privileges in MS Access and the secrecy level (or data classification) of information contained in database management system (DBMS). Second, an advanced technique will be used to take advantage of access control mechanisms and the use of cryptographic fundamentals in Microsoft access applications to provide a balanced approach that makes tradeoffs between the convenience of access to confidential data by authorized users and preserving the integrity and secrecy of sensitive and critical data