ABSTRACT Leading enterprises typically choose for a centralized, large‐scale database storage system. Data security is crucial for communication and database preservation. The principal issue is governing unauthorized access to the database. Role‐based access control (RBAC) is a recognized approach for maintaining confidentiality in database systems. Nevertheless, System Administrators (SA) and Database Administrators (DBA) can obtain critical information even within the RBAC architecture. An approach based on encryption has been developed to address this issue. The primary concern is the secure distribution of keys among individuals with shared data access and a group of individuals needing access to shared data, viewed as having a common objective. We have instituted row‐level security (RLS) in database design to establish safe access control, called Encrypted Role‐Based Access Control (ERBAC). Additionally, we deployed Enterprise Resource Planning (ERP) systems, which are essential applications where security concerns are critical. ERBAC integrates effortlessly with an operational ERP system. We offer security, performance analysis, and encrypted query processing for role‐based encrypted data storage when the database contains identical data in many forms.
Maji et al. (Fri,) studied this question.