Sieve: A Middleware Approach to Scalable Access Control for Database Management Systems

04/16/2020
by   Primal Pappachan, et al.
0

Current approaches of enforcing FGAC in Database Management Systems (DBMS) do not scale in scenarios when the number of policies are in the order of thousands. This paper identifies such a use case in the context of emerging smart spaces wherein systems may be required by legislation, such as Europe's GDPR and California's CCPA, to empower users to specify who may have access to their data and for what purposes. We present Sieve, a layered approach of implementing FGAC in existing database systems, that exploits a variety of it's features such as UDFs, index usage hints, query explain; to scale to large number of policies. Given a query, Sieve exploits it's context to filter the policies that need to be checked. Sieve also generates guarded expressions that saves on evaluation cost by grouping the policies and cuts the read cost by exploiting database indices. Our experimental results, on two DBMS and two different datasets, show that Sieve scales to large data sets and to large policy corpus thus supporting real-time access in applications including emerging smart environments.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
09/21/2019

Graph Model Implementation of Attribute-Based Access Control Policies

Attribute-based access control (ABAC) promises a powerful way of formali...
research
09/26/2019

Fine-Grained, Language-Based Access Control for Database-Backed Applications

Context: Database-backed applications often run queries with more author...
research
11/20/2018

ESTRELA: Automated Policy Enforcement Across Remote APIs

Web applications routinely access sensitive and confidential data of use...
research
11/22/2019

Multi-User Multi-Device-Aware Access Control System for Smart Home

In a smart home system, multiple users have access to multiple devices, ...
research
12/01/2019

Purpose-based access policy on provenance and data algebra

It is a crucial mechanism of access control to determine that data can o...
research
12/11/2009

Design of Intelligent layer for flexible querying in databases

Computer-based information technologies have been extensively used to he...
research
09/12/2022

Optimising Fine-Grained Access Control Policy Enforcement for Database Queries. A Model-Driven Approach

Recently, we have proposed a model-driven approach for enforcing fine-gr...

Please sign up or login with your details

Forgot password? Click here to reset