Internal security system for a relational database system
View Patent ↗An internal security method for use with a relational database system is disclosed. The method is incorporated into a database system such that there is no need for security coding be layered on top of the system application software to prevent unauthorized access to restricted database information. The method of the present invention includes at least two embodiments and at least one of the embodiments has a “down the tree view” structure.
1. An internal security method for a relational database system, comprising one or more processors implementing the steps of:
(a) determining which data information from the total amount of data information stored in system databases is restricted data information that shall not be accessible by each and every 1 to N system users, where N is an integer greater than 1;
(b) determining for each individual specific system user the restricted data information that such a system user shall have access;
(c) creating at least one relational access table with each specific system user having at least one record in the relational access table and using a foreign key in the table created at step (c) that is linked to a primary key associated with a specific system user's table of the relational database system for controlling that specific system user's access to the restricted data information that was determined at step (b) and preventing downstream and upstream access to unauthorized restricted data information through the use of the foreign key and primary key link, such that a first specific system user will have one or more records in the relational access table that will permit the first specific system user's access to restricted data information that is determined for the first specific system user to be joined with a second specific system user's access to restricted data information that is determined for the second specific system user, and the specific second system user will have one or more records in the relational access table that will permit the second specific system user's access to restricted data information that is determined for the second specific system user; and
(d) each specific system user accessing restricted data information stored in the system databases according to the relational access table created at step (c) and specific one way joining links to restricted data information stored in the system databases of other system users according to step (c).
2. The method as recited in claim 1 , wherein the relational database is a structured query language database.
3. The method as recited in claim 1 , wherein each relational access table has a foreign key that relates to a primary key of only one specific system user.
4. The method as recited in claim 1 , wherein each relational access table created at step (c) may have access to additional restricted data information added to it by updating the relational access table after it is created.
5. The method as recited in claim 1 , wherein each relational access table created at step (c) may have access to certain restricted data information deleted from it by updating the relational access table after it is created.
6. The method as recited in claim 1 , wherein the relational database system that incorporates the internal security method includes a star schema configuration.
7. The method as recited in claim 6 , wherein the relational database system that incorporates the internal security method includes a full star schema configuration.