The implementation of security polices in data warehouse

Marcin Gorawski, Jacek Frączek

Abstract


This research describes the process of implementation of a security system that controls access to detail information in a ROLAP data warehouse. The Human Resources Analysis System is presented as an example for a practical implementation of complex security policies. Two methods of implementation of the security system arę described and discussed: database views and virtual private databases.

Keywords


data warehouses; security system; row-level access control



DOI: http://dx.doi.org/10.21936/si2004_v25.n1.628