Invention Grant
US08667018B2 Method and system for optimizing row level security in database systems
有权
优化数据库系统中行级安全性的方法和系统
- Patent Title: Method and system for optimizing row level security in database systems
- Patent Title (中): 优化数据库系统中行级安全性的方法和系统
-
Application No.: US12188675Application Date: 2008-08-08
-
Publication No.: US08667018B2Publication Date: 2014-03-04
- Inventor: Mohammed Irfan Rafiq , Chon Hei Lei , Vikram Kapoor , Thomas F. Keefe , Nipun Agarwal , Thomas Baby , Sam Idicula , Vikram Reddy Pesati
- Applicant: Mohammed Irfan Rafiq , Chon Hei Lei , Vikram Kapoor , Thomas F. Keefe , Nipun Agarwal , Thomas Baby , Sam Idicula , Vikram Reddy Pesati
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Park, Vaughan, Fleming & Dowler LLP
- Agent Shun Yao
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30
Abstract:
One embodiment of the present invention provides a system that implements a security policy in a database. During operation, the system receives a request associated with a set of objects in the database. Next, the system obtains a set of access control lists (ACLs) associated with the database, wherein a respective ACL specifies one or more access privileges associated with a user or user group, and wherein a respective ACLs is not specific to a particular object in the database. The system then evaluates the ACLs to obtain a set of ACL results associated with the request and processes the request by applying the set of ACL results to the objects without evaluating the ACLs repeatedly for each of the objects.
Public/Granted literature
- US20100036846A1 METHOD AND SYSTEM FOR OPTIMIZING ROW LEVEL SECURITY IN DATABASE SYSTEMS Public/Granted day:2010-02-11
Information query
