Cell-based security representation for data access

Details Cell-based security representation for data access Cell-based security representation for data access

2011-06-28

2011-06-28

Le, Uyen T. (Department: 2157)

Data processing: database and file management or data structures

Database and file access

Database access control methods

Reexamination Certificate

active

07970790

ABSTRACT:
Architecture for cell-based security on a per-user basis. A security model for this capability includes not only dimension level tables, but is extended to include cell level tables. The security model can include existing dimension tables, plus cell security tables that include a cell permissions table, a cell qualifiers table and a table that includes both the cell permissions table, a cell qualifiers. Metadata associated with the security applied to the cells for a given user can be stored locally in a local metadata store for retrieval and application against a data cube that an authenticated and authorized user is querying. In a specific implementation, the cell level security is employed in a performance management server application, where authentication is performed remotely by an authentication service, but the authorization function is performed local to the performance management server application.

REFERENCES:
patent: 5940818 (1999-08-01), Malloy et al.
patent: 6592626 (2003-07-01), Bauchot et al.
patent: 7155612 (2006-12-01), Licis
patent: 7200595 (2007-04-01), Dutta et al.
patent: 7243097 (2007-07-01), Agrawal et al.
patent: 7340770 (2008-03-01), Freund
patent: 2002/0095405 (2002-07-01), Fujiwara
patent: 2005/0177570 (2005-08-01), Dutta et al.
patent: 2005/0289342 (2005-12-01), Needham et al.
patent: 2006/0010118 (2006-01-01), Sattler et al.
patent: 2006/0206485 (2006-09-01), Rubin et al.
patent: 2007080562 (2007-07-01), None
“Introduction to MOSS Security Architecture”, 2006, ARB Security Solutions, LLC, 2 pages.
Rask, et al., “Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005”, Apr. 1, 2005, Microsoft Corporation, 7 pages.
“Cell-Level Security in SQL Server 7.0 OLAP Services”, 2007, Microsoft Corporation, 2 pages.
“Website Security & Authentication Software”, 2000-2006, InetSolution, Inc., 20 pages.
International Search Report, mailed Nov. 24, 2009, 13 pages.

Affiliated with

Also associated with

Rating

Cell-based security representation for data access does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Cell-based security representation for data access, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Cell-based security representation for data access will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2643513