Fine-grained access control in a database by preventing information leakage and removing redundancy
US7685194B2 · kind B2 · utility
32Cited by
1References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Aug 31, 2006 |
| Grant date | Mar 23, 2010 |
| Priority date | — |
| Expiry date | May 1, 2027 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24547
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Fine-grained access control for querying a database with low overhead and safety plans. In a view placement approach, base relations of the query expression are replaced by views that are appropriate for the particular user. Information leakage via UDF pushing, exception processing, and error messages can be prevented by generating safe plans. An existing query optimizer can be modified to perform redundancy removal and safe plan implementation. Subsumption testing available in materialized view matching can be exploited by the query optimizer. Authorization inference is exploited to generate safe plans.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.