Developing access control model of web OLAP over trusted and collaborative data warehouses

• Main Authors: Somchart Fugkeaw, Jarernsri L. Mitrpanont, Piyawit Manpanpanich, Sekpon Juntapremjitt
• Other Authors: Thai Digital ID Co.
• Format: Chapter
• Published: 2018
• Subjects: Business, Management and Accounting; Computer Science; Decision Sciences
• Online Access: https://repository.li.mahidol.ac.th/handle/123456789/28874
• Institution: Mahidol University

© Springer-Verlag London Limited 2010. This paper proposes the design and development of Role- based Access Control (RBAC) model for the Single Sign-On (SSO) Web-OLAP query spanning over multiple data warehouses (DWs). The model is based on PKI Authentication and Privilege Management Infrastructure (PMI); it presents a binding model of RBAC authorization based on dimension privilege specified in attribute certificate (AC) and user identification. Particularly, the way of attribute mapping between DW user authentication and privilege of dimensional access is illustrated. In our approach, we apply the multi-agent system to automate flexible and effective management of user authentication, role delegation as well as system accountability. Finally, the paper culminates in the prototype system A-COLD (Access Control of web-OLAP over multiple DWs) that incorporates the OLAP features and authentication and authorization enforcement in the multi-user and multi-data warehouse environment.