Patent · US Active

Persisted data views supporting access control

US12061712B2 · kind B2 · utility

0Cited by

1References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Michael Wilking · Walldorf, DE
Michael te Uhle · Rhede, DE
Florian Maier · Glückstadt, DE
Ioannis Kostis · Heidelberg, DE
Atul Rajendra Prasad Tiwari · Hockenheim, DE
Leonardo Silva Rosa · Porto Alegre, BR

Key dates

Filing date	Oct 29, 2021
Grant date	Aug 13, 2024
Priority date	—
Expiry date	Jan 28, 2042

Classification

Technology area (CPC G)Physics
CPC primaryG06F2221/2141
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Embodiments enforce user access rights to a data view, by initially generating a replication table of the view. The replication table may include all view data to which any user is entitled. This replication table may be generated during a first database session having a first value for a session variable. Next, a data access control structure is applied to the replication table to produce output comprising a subset of the view data for a specific user. This output may be produced during a second database session having a second value for the session variable. By initially generating the view replication table up front, processing resources are conserved in later stages when access control structures are applied to grant view access rights to particular users. Alternative embodiments may implement access control to data views, through the creation and storage of derived views.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.