发明名称 |
Managing materialized query tables (MQTS) over fine-grained access control (FGAC) protected tables |
摘要 |
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.
|
申请公布号 |
US8515948(B2) |
申请公布日期 |
2013.08.20 |
申请号 |
US201113044415 |
申请日期 |
2011.03.09 |
申请人 |
CHEN YAO-CHING S.;COTNER CURT L.;KIERNAN GERALD G.;KUANG DAVID J.;LIU IRENE C.;LIU REGINA J.;RJAIBI WALID;VINCENT TIMOTHY J.;INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
CHEN YAO-CHING S.;COTNER CURT L.;KIERNAN GERALD G.;KUANG DAVID J.;LIU IRENE C.;LIU REGINA J.;RJAIBI WALID;VINCENT TIMOTHY J. |
分类号 |
G06F7/00;G06F17/30 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|