System, method and computing apparatus to isolate a database in a database system
US9715513B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 17, 2015 |
| Grant date | Jul 25, 2017 |
| Priority date | — |
| Expiry date | Apr 17, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/278
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The present invention relates to a system, method and computing apparatus to isolate a database in a database system. The disclosure of the present invention enables more efficient and more secured implementation of “database isolation” in a multi-tenant or multi-user database system storing service data belonging to different users. The user identifier(s) are extracted from the default database, creating a user table according to the extracted user identifier(s), creating a service table in the main database with owner user identifier column and owner group identifier column inserted, it can efficiently create view to a user when the user requests to access the service data which the user owns or the user is authorized to access. The created service table with owner user identifier column and owner group identifier column inserted achieve database isolation at database level, and the created view achieves database isolation at application level.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.