Persisted data views supporting access control

    公开(公告)号:US12061712B2

    公开(公告)日:2024-08-13

    申请号:US17514983

    申请日:2021-10-29

    Applicant: SAP SE

    CPC classification number: G06F21/6227 G06F16/2393 G06F21/604 G06F2221/2141

    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.

    Persisted Data Views Supporting Access Control

    公开(公告)号:US20230022454A1

    公开(公告)日:2023-01-26

    申请号:US17514983

    申请日:2021-10-29

    Applicant: SAP SE

    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.

Patent Agency Ranking