Indexed security for use with databases
A computer-implemented method for providing security in a relational database hosted by a first server, and configured to interact with a second server, includes associating a first ownership vector with an object in the relational database, detecting a change to the object, and associating a second ownership vector with the object in response to detecting the change to the object.
1. A computer-implemented method for providing security in a relational database hosted by a first server and configured to interact with a second server, said computer-implemented method comprising:
by a hardware processor:
in the relational database, associating a first ownership vector with an object in the relational database, wherein associating a first ownership vector comprises determining access rights defined for the object;
detecting one of a change relating to the object and a change to the object, wherein detecting a change related to the object comprises detecting a change to the access rights defined for the object; and
associating a second ownership vector with the object in response to detecting the change, wherein associating a second ownership vector comprises determining an appropriate ownership vector based on the change and breaking the association between the first ownership vector and the object in response to the change.
2. The computer-implemented method in accordance with claim 1 , wherein associating a second ownership vector comprises determining an appropriate ownership vector based on the change to the access rights.
3. The computer-implemented method in accordance with claim 1 , wherein associating a second ownership vector comprises breaking the association between the first ownership vector and the object in response to the change to the access rights.
4. The computer-implemented method in accordance with claim 1 , wherein associating a second ownership vector comprises detecting at least one of a broken association between the first ownership vector and the object and a new object having no associated ownership vector.
5. The computer-implemented method in accordance with claim 1 , wherein at least one of the first server and the second server includes application logic, said computer-implemented method further comprising:
receiving a query via the application logic; and
performing a search of the relational database based on the query, wherein the query includes criteria related to at least one of the first ownership vector and the second ownership vector.
6. A computer device comprising:
a memory area configured to store a relational database, the relational database configured to interact with a remote computer device; and
a hardware processor coupled to said memory area, said processor configured to:
in the relational database, associate a first ownership vector with an object in the relational database, wherein associating a first ownership vector comprises determining access rights defined for the object;
detect one of a change relating to the object and a change to the object, wherein detecting a change related to the object comprises detecting a change to the access rights defined for the object; and
associate a second ownership vector with the object in response to detecting the change, wherein associating a second ownership vector comprises determining an appropriate ownership vector based on the change and breaking the association between the first ownership vector and the object in response to the change.
7. The computer device in accordance with claim 6 , wherein said processor is configured to determine an appropriate ownership vector based on the change to the access rights.
8. The computer device in accordance with claim 6 , wherein said processor is configured to break the association between the first ownership vector and the object in response to the change to the access rights.
9. The computer device in accordance with claim 6 , wherein said processor is further configured to detect at least one of a broken association between the first ownership vector and the object and a new object having no associated ownership vector.
10. The computer device in accordance with claim 6 , wherein said processor is further configured to:
receive a query via application logic; and
perform a search of the relational database based on the query, wherein the query includes criteria related to at least one of the first ownership vector and the second ownership vector.
11. A computer system comprising:
a memory area configured to store a relational database;
at least one application server with a hardware processor coupled to said memory area, said at least one application server configured to:
in the relational database, associate a first ownership vector with an object in the relational database, wherein associating a first ownership vector comprises determining access rights defined for the object;
detect one of a change related to the object and a change to the object, wherein detecting a change related to the object comprises detecting a change to the access rights defined for the object; and
associate a second ownership vector with the object in response to detecting the change, wherein associating a second ownership vector comprises determining an appropriate ownership vector based on the change and breaking the association between the first ownership vector and the object in response to the change.
12. The computer system in accordance with claim 11 , wherein said at least one application server is configured to determine an appropriate ownership vector based on the change to the access rights.
13. The computer system in accordance with claim 11 , wherein said at least one application server is configured to break the association between the first ownership vector and the object in response to the change to the access rights.
14. The computer system in accordance with claim 11 , wherein said at least one application server is configured to detect at least one of a broken association between the first ownership vector and the object and a new object having no associated ownership vector.
15. The computer system in accordance with claim 11 , wherein said at least one application server comprises a first application sever coupled to said memory area and a second application server communicatively coupled to said first application server, wherein said first application server is further configured to:
receive a query via said second application server; and
perform a search of the relational database based on the query, wherein the query includes criteria related to at least one of the first ownership vector and the second ownership vector.