Patent US5751949A successfully refreshed from Google Patents.
US5751949A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Data security system and method
Assignee: MCI Corp
•
Filing: 1995-05-23
•
Granted: 1998-05-12
•
Expires: 2015-05-23
Abstract
Abstract A security system and method are provided for securing user access to server tables having data arranged in rows and columns. The server table is contained in a server computer which is accessible by a plurality of user terminals joined thereto. The server computer includes relational database software for creating and maintaining tables, including the server table, and views defining subsets of the tables. A security table is stored in the computer for identifying authorized user access to preselected rows of the server table for pre-identified users. An access view is stored in the computer for automatically joining the security and server tables to limit user access to the server table to the preselected rows thereof based on the security table. A single security table may therefore be used and is readily updated by merely deleting, adding, or updating entries.
Inventors
- 👤 Robert David Thomson
- 👤 Roger Geiwitz
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 03:31
CPC Classifications
G; G06; G06F; G06F21/00; G06F21/60; G06F21/62; G06F21/6218; G06F21/6227
Claims Analysis
Total Claims: 15
Claim 1
Independent Claim
128 words
A security system for providing user authorized access to a server table having data arranged in rows and columns comprising: a server computer for storing said server table; a plurality of user terminals operatively joined to said computer for providing access to said server table; relational database software stored in said computer and operable by an administrator for creating and maintaining tables, including said server table, and views defining subsets of said tables; a security table stored in said computer for identifying authorized user access to preselected rows of said server table for pre-identified users; and an access view stored in said computer for joining said security and server tables to limit user access to said server table to said preselected rows thereof based on said security table.
Claim 2
Dependent Claim
128 words
A security system for providing user authorized access to a server table having data arranged in rows and columns comprising: a server computer for storing said server table; a plurality of user terminals operatively joined to said computer for providing access to said server table; relational database software stored in said computer and operable by an administrator for creating and maintaining tables, including said server table, and views defining subsets of said tables; a security table stored in said computer for identifying authorized user access to preselected rows of said server table for pre-identified users; and an access view stored in said computer for joining said security and server tables to limit user access to said server table to said preselected rows thereof based on said security table.
Claim 3
Dependent Claim
80 words
A security system according to claim 1 further comprising: a preselected user identification ID associated with a given user; a row label associated with each row of said server table; and wherein: said security table includes a column of preselected user ID's and a corresponding column of authorized-access row labels for said user ID's, respectively; and said access view is configured to allow user access to authorized rows of said server table based on said user ID's and row labels.
Claim 4
Dependent Claim
42 words
A security system according to claim 2 further comprising a plurality of said server tables and a respective plurality of said views for allowing row access to each of said server tables based on a respective one of said views configured therefor.
Claim 5
Dependent Claim
45 words
A security system according to claim 3 wherein: said server tables have different row labels; said security table includes a plurality of columns for said different row labels corresponding to said user ID's; and said views are configured for respective ones of said row labels.
Claim 6
Dependent Claim
21 words
A security system according to claim 3 wherein said security table includes a single record per row label per user ID.
Claim 7
Dependent Claim
20 words
A security system according to claim 5 wherein said security table includes duplicate user ID's with different row labels, respectively.
Claim 8
Dependent Claim
35 words
A security system according to claim 3 wherein said relational database software is configured to allow user read access solely to said views and said security table, and no direct access to said server tables.
Claim 9
Independent Claim
102 words
A method of securing access to a server table having data arranged in rows and columns and stored in a server computer configured with relational database software for creating and maintaining tables, including said server table, and views defining subsets of said tables, said method comprising: creating a security table in said computer for authorizing user access to preselected rows of said server table for pre-identified users; and creating an access view in said computer for automatically joining said security table and said server table to limit user access to said server table to preselected rows thereof based on said security table.
Claim 10
Independent Claim
102 words
A method of securing access to a server table having data arranged in rows and columns and stored in a server computer configured with relational database software for creating and maintaining tables, including said server table, and views defining subsets of said tables, said method comprising: creating a security table in said computer for authorizing user access to preselected rows of said server table for pre-identified users; and creating an access view in said computer for automatically joining said security table and said server table to limit user access to said server table to preselected rows thereof based on said security table.
Claim 11
Dependent Claim
20 words
A method according to claim 8 further comprising allowing user access to said server table solely through said access view.
Claim 12
Dependent Claim
80 words
A method according to claim 9 further comprising: providing a preselected user ID associated with a given user; providing a row label associated with each row of said server table; providing in said server table a column of preselected user ID's and a corresponding column of authorized-access row labels for said user ID's, respectively; and providing in said access view authorization to allow user access to authorized rows of said server table based on said user ID's and row labels.
Claim 13
Dependent Claim
20 words
A method according to claim 10 wherein said security table includes a single record per row label per user ID.
Claim 14
Dependent Claim
19 words
A method according to claim 11 wherein said security table includes duplicate user ID's with different row labels, respectively.
Claim 15
Dependent Claim
24 words
A method according to claim 12 further comprising updating said security table by adding or deleting user ID and respective row label entries therein.
References Cited (Backward Citations)
US5021995A
Cited
US5065429A
Cited
US5182705A
Cited
US5272628A
Cited
US5058162A
Cited
US5421001A
Cited
US5345549A
Cited
US5440735A
Cited
US5483596A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-05-11 | 2001-11-10 | 2002-05-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-05-11 | 2005-11-10 | 2006-05-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-05-11 | 2009-11-10 | 2010-05-12 | $7700.00 | Window Closed / Lapsed |