发明授权
US08515948B2 Managing materialized query tables (MQTS) over fine-grained access control (FGAC) protected tables
有权
通过细粒度访问控制（FGAC）受保护的表管理物化查询表（MQTS）
- 专利标题： Managing materialized query tables (MQTS) over fine-grained access control (FGAC) protected tables
- 专利标题（中）： 通过细粒度访问控制（FGAC）受保护的表管理物化查询表（MQTS）
-
申请号： US13044415申请日： 2011-03-09
-
公开(公告)号： US08515948B2公开(公告)日： 2013-08-20
- 发明人: Yao-Ching S. Chen , Curt L. Cotner , Gerald G. Kiernan , David J. Kuang , Irene C. Liu , Regina J. Liu , Walid Rjaibi , Timothy J. Vincent
- 申请人： Yao-Ching S. Chen , Curt L. Cotner , Gerald G. Kiernan , David J. Kuang , Irene C. Liu , Regina J. Liu , Walid Rjaibi , Timothy J. Vincent
- 申请人地址： US NY Armonk
- 专利权人： International Business Machines Corporation
- 当前专利权人： International Business Machines Corporation
- 当前专利权人地址： US NY Armonk
- 代理机构： Konrad, Raynes, Davda & Victor LLP
- 代理商 Janaki K. Davda
- 主分类号： G06F7/00
- IPC分类号： G06F7/00 ; G06F17/30
摘要：
Provided are techniques for creating one or more fine-grained access control rules that are associated with a base table. A materialized query table is created from the base table without applying the one or more fine-grained access control rules associated with the base table when obtaining data from the base table. A fine-grained access control protection indicator is turned on for the materialized query table. In response to receiving a direct access request to the materialized query table in a query referencing the materialized query table, access is provided to the data in the materialized query table by applying one or more fine-grained access control rules associated directly with the materialized query table to the data in the materialized query table before returning the data.
公开/授权文献
信息查询
