Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-10-09
2007-10-09
Kindred, Alford W. (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
10943189
ABSTRACT:
A method and mechanism are provided for accessing data. Values are stored for a set of context attributes associated with a session between a database user and a database server. The database system includes an attribute setting mechanism that selectively restricts access to the set of context attributes based on a policy. During the session, the database server executes a query that contains a reference to one or more of the context attributes. For example, the query may contain a predicate that requires a comparison between a context attribute value and a constant. The database server processes the query based on current values of the one or more of the context attributes referenced in the query. A mechanism is also provided for dynamically attaching predicates to queries, where the predicates are attached based on a policy. For example, the database system detects that a query is issued against a database object. Prior to executing the query, a policy function associated with the database object is invoked. The policy function creates a modified query by selectively adding zero or more predicates to the query based on a policy associated with the database object. The modified query is then executed.
REFERENCES:
patent: 5265221 (1993-11-01), Miller
patent: 5276901 (1994-01-01), Howell et al.
patent: 5335346 (1994-08-01), Fabbio
patent: 5428778 (1995-06-01), Brookes
patent: 5659738 (1997-08-01), Letkeman et al.
patent: 5751949 (1998-05-01), Thomson et al.
patent: 5765154 (1998-06-01), Horikiri et al.
patent: 5787428 (1998-07-01), Hart
patent: 5815574 (1998-09-01), Fortinsky
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5940818 (1999-08-01), Malloy et al.
patent: 5963932 (1999-10-01), Jakobsson et al.
patent: 6035298 (2000-03-01), McKearney
patent: 6134549 (2000-10-01), Regnier et al.
patent: 6366904 (2002-04-01), BenHadda et al.
patent: 6449609 (2002-09-01), Witkowski
patent: 6487552 (2002-11-01), Lei et al.
patent: 6578037 (2003-06-01), Wing et al.
patent: 6618721 (2003-09-01), Lee
patent: 6631371 (2003-10-01), Lei et al.
patent: 6757670 (2004-06-01), Inohara et al.
patent: 6986060 (2006-01-01), Wong
patent: 6996557 (2006-02-01), Leung et al.
patent: 7117197 (2006-10-01), Wong et al.
patent: 2001/0021929 (2001-09-01), Lin et al.
patent: 2002/0095405 (2002-07-01), Fujiwara
patent: 2003/0014394 (2003-01-01), Fujiwara et al.
patent: 2003/0236782 (2003-12-01), Wong et al.
patent: 2004/0139043 (2004-07-01), Lei et al.
patent: 2004/0254948 (2004-12-01), Yao
patent: 2005/0050046 (2005-03-01), Puz et al.
patent: 2005/0144176 (2005-06-01), Lei et al.
patent: 2005/0177570 (2005-08-01), Dutta et al.
Michael Stonebraker et al., “Access Control in a Relational Data Base Management System by Query Modification,” ACM/CSC-ER, 1974, XP-002319462, pp. 180-186.
T.F. Keefe et al., “Secure Query-Processing Strategies,” IEEE, No. 3, Mar. 1989, XP 000122365, pp. 63-70.
International Search Authority, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority, or the Declaration,” International Application No. PCT/US2004/043480, Apr. 22, 2005, 12 pages.
Current Claims Of International Application No. PCT/US2004/043480, pp. 1-6.
Lei Chon Hei
McMahon Douglas James
Kindred Alford W.
Oracle International Corporation
LandOfFree
Database fine-grained access control does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database fine-grained access control, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database fine-grained access control will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3889350