Somchart FugkeawJarernsri L. MitrpanontPiyawit ManpanpanichSekpon JuntapremjittThai Digital ID Co.Mahidol UniversityWhitehat Certified Co. Ltd.2018-09-242018-09-242010-01-01Advanced Information and Knowledge Processing. Vol.53, (2010), 393-41321978441161039472-s2.0-84951294393https://repository.li.mahidol.ac.th/handle/123456789/28874© 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.Mahidol UniversityBusiness, Management and AccountingComputer ScienceDecision SciencesChapterSCOPUS10.1007/978-1-84996-074-8_15