Data security system and method
First Claim
1. 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.
3 Assignments
0 Petitions
Accused Products
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.
-
Citations
13 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. 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. - View Dependent Claims (9, 10, 11, 12, 13)
-
Specification