Secure access to multi-tenant relational data
US11068617B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Oct 9, 2017 |
| Grant date | Jul 20, 2021 |
| Priority date | — |
| Expiry date | Mar 25, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F3/0482
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Access to an individual tenant's data within a multi-tenant relational database architecture is provided, without unduly exposing data of other tenants. A list of accessible tables is presented to an authenticated individual, such as a developer. Specific information can be designated as sensitive and can be excluded from the information the developer can access. A specialized user interface provides secure point-and-click access to data by allowing selection of a set of higher-level data types to retrieve. Access to data from a related table can be enabled by providing a hyperlink that, when activated, retrieves a relevant record from the related table. Primary key values can also be rendered as hyperlinks that can activate a pop-up menu showing all tables that refer to that primary key value. In at least one embodiment, SQL queries are automatically constructed based on the user's selection of items from the pop-up menu.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.