数据仓库权限系统及基于FGAC的实现

Authority system in data warehouse based FGAC

本文就数据仓库的安全策略、访问控制方法进行了探讨归纳;并采用基于FGAC(精细权限控制)的方式设计一套访问数据仓库数据的权限控制方案,可以有效的根据维的分层信息控制用户对事实表和维表的数据访问权限。

This paper discuss and summarize the security policy and access control in data warehouse and pats forward a method to control the datum in data warehouse based on FGAC （Fine Grained Access Control） so as to control the access of users to the fact table and dimension table based on the information of level in dimension.