Pappachan, PrimalYus, RobertoMehrotra, SharadFreytag, Johann-Christoph2022-06-072022-06-072020-09-14Primal Pappachan, Roberto Yus, Sharad Mehrotra, and Johann-Christoph Freytag. 2020. Sieve: a middleware approach to scalable access control for database management systems. Proc. VLDB Endow. 13, 12 (August 2020), 2424–2437. DOI:https://doi.org/10.14778/3407790.3407835https://doi.org/10.14778/3407790.3407835http://hdl.handle.net/11603/24843Current approaches for enforcing Fine Grained Access Control (FGAC) in DBMS do not scale to scenarios when the number of access control 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 DBMSs, that exploits a variety of their features (e.g., UDFs, index usage hints, query explain) to scale to a large number of policies. Given a query, Sieve exploits its context to filter the policies that need to be checked. It also generates guarded expressions that save on evaluation cost by grouping policies and exploit database indices to cut on read cost. Our experimental results demonstrate that existing DBMSs can utilize Sieve to significantly reduce query-time policy evaluation cost. Using Sieve DBMSs can support real-time access control in applications such as emerging smart environments.14 pagesen-USThis item is likely protected under Title 17 of the U.S. Copyright Law. Unless on a Creative Commons license, for uses protected by Copyright Law, contact the copyright holder or the author.Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0)https://creativecommons.org/licenses/by-nc-nd/4.0/Text