Multi-table access control

Details Multi-table access control Multi-table access control

2004-01-23

2008-03-18

Mofiz, Apu (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C711S163000, C726S027000, C726S028000, C726S029000, C726S030000

Reexamination Certificate

active

07346617

ABSTRACT:
Multi-table access control is disclosed that limits access to tables when a requirement for access to multiple columns is detected, where the multiple columns includes at least one column from one table and another column from another table. In an embodiment, the detection of the requirement for access to multiple columns triggers a policy to rewrite the query to include a condition expression that limits access to the multiple columns to those that are entitled to access.

REFERENCES:
patent: 5335346 (1994-08-01), Fabbio
patent: 5721848 (1998-02-01), Joseph
patent: 5819251 (1998-10-01), Kremer et al.
patent: 5832226 (1998-11-01), Suzuki et al.
patent: 5850507 (1998-12-01), Ngai et al.
patent: 5860144 (1999-01-01), Frank et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5873106 (1999-02-01), Joseph
patent: 5893166 (1999-04-01), Frank et al.
patent: 5918236 (1999-06-01), Wical
patent: 6006234 (1999-12-01), Govindarajan et al.
patent: 6014656 (2000-01-01), Hallmark et al.
patent: 6058389 (2000-05-01), Chandra et al.
patent: 6112226 (2000-08-01), Weaver et al.
patent: 6119154 (2000-09-01), Weaver et al.
patent: 6138147 (2000-10-01), Weaver et al.
patent: 6173313 (2001-01-01), Klots et al.
patent: 6182241 (2001-01-01), Ngai et al.
patent: 6226649 (2001-05-01), Bodamer et al.
patent: 6275825 (2001-08-01), Kobayashi et al.
patent: 6334128 (2001-12-01), Norcott et al.
patent: 6405212 (2002-06-01), Samu et al.
patent: 6405274 (2002-06-01), Chan
patent: 6449609 (2002-09-01), Witkowski
patent: 6460052 (2002-10-01), Thomas et al.
patent: 6470344 (2002-10-01), Kothuri et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6484180 (2002-11-01), Lyons et al.
patent: 6487552 (2002-11-01), Lei et al.
patent: 6510504 (2003-01-01), Satyanarayanan
patent: 6516317 (2003-02-01), Samar et al.
patent: 6529906 (2003-03-01), Chan
patent: 6549916 (2003-04-01), Sedlar
patent: 6564203 (2003-05-01), Krishnaprasad et al.
patent: 6574654 (2003-06-01), Simmons et al.
patent: 6578037 (2003-06-01), Wong et al.
patent: 6587854 (2003-07-01), Guthrie et al.
patent: 6604182 (2003-08-01), Sexton et al.
patent: 6606627 (2003-08-01), Guthrie et al.
patent: 6615223 (2003-09-01), Shih et al.
patent: 6618744 (2003-09-01), Simmons et al.
patent: 6631371 (2003-10-01), Lei et al.
patent: 6636870 (2003-10-01), Roccaforte
patent: 6668270 (2003-12-01), Simmons et al.
patent: 6668295 (2003-12-01), Chan
patent: 6678676 (2004-01-01), Brickell et al.
patent: 6704767 (2004-03-01), Simmons et al.
patent: 6708198 (2004-03-01), Simmons et al.
patent: 6715146 (2004-03-01), Simmons et al.
patent: 6745332 (2004-06-01), Wong et al.
patent: 6996557 (2006-02-01), Leung et al.
patent: 7117197 (2006-10-01), Wong et al.
patent: 2002/0194211 (2002-12-01), Subramanian et al.
patent: 2003/0014394 (2003-01-01), Fujiwara et al.
patent: 2003/0055832 (2003-03-01), Roccaforte
patent: 2003/0065659 (2003-04-01), Agrawal et al.
patent: 2003/0200197 (2003-10-01), Long et al.
patent: 2003/0208503 (2003-11-01), Roccaforte
patent: 2003/0236781 (2003-12-01), Lei et al.
patent: 2003/0236782 (2003-12-01), Wong et al.
patent: 2004/0054933 (2004-03-01), Wong et al.
patent: 2004/0088340 (2004-05-01), Idicula et al.
patent: 2004/0254948 (2004-12-01), Yao
Oracle Corporation, “Summary of Subprograms,” Oracle8iSupplied PL/SQL Packages Reference, Release 2 (8.1.6), Part No. A76936-01, 1996-2000, http://download-west.oracle.com/docs/cd/A87860—01/doc/appdev.817/a76936/dbhms—rl2, data retrieved Dec. 18, 2003, pp. 1-7.
Oracle Corporation, “Summary of DBMS—FGA Subprograms,” Oracle9iSupplied PL/SQL Packages and Types Reference, Release 2 (9.2), Part No. A96612-01, 2000, 2002, http://download-west.oracle.com/docs/cd/B10501—01/appdev.920/a96612/d—fga2, data retrieved Dec. 18, 2003, pp. 1-4.
Oracle Corporation, “Accessing a Workplace from OLAP Worksheet,” Oracle9iOLAP Developer's Guide to the OLAP DML, Release 2 (9.2), Part No. A95298-01, 2001, 2002, http://download-west.oracle.com/docs/cd/B10501—01/olap.920/a95298/basics4.htm—-—1006174, data retrieved Dec. 19, 2003, pp. 1-4.
Oracle Corporation, “Advanced Topics,” Pro*C/C++ Precompiler Programmer's Guide, Release 9.2, Part No. A97269-01, 1996, 2002, http://download-west.oracle.com/docs/cd/B10501—01/appdev.920/a97269/pc—05adv.htm, data retrieved Dec. 19, 2003, pp. 1-48.
Oracle Corporation, “Basic Concepts,” Oracle9iReports Building Reports, Release 9.0, Part No. B10310-01, 2002, http://otn.oracle.com/products/reports/htdocs/getstart/docs/b10310—01/orbr—concepts1.htm, data retrieved Dec. 19, 2003, pp. 1-43.
Oracle Corporation, “Privileges, Roles, and Security Policies,” Oracle9iDatabase Concepts, Release 2 (9.2), Part No. A96524-01, 1996, 2002, http://download-west.oracle.com/docs/cd/B10501—01/server.920/a96524/c24privs.htm, data retrieved Dec. 18, 2003, pp. 1-22.
Oracle Corporation, “Implementing Application Security Policies,” Oracle9iApplication Developer's Guide—Fundamentals, Release 2 (9.2), Part No. A96590-01, 1996, 2002, http://download-west.oracle.com/docs/cd/B10501—01/appdev.920/a96590/adgsec02.htm, data retrieved Dec. 18, 2003, pp. 1-49.

Affiliated with

Also associated with

Rating

Multi-table 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 Multi-table access control, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multi-table access control will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3965281