优化数据库管理的细粒度访问控制策略执行。模型驱动的方法
Optimising Fine-Grained Access Control Policy Enforcement for Database Queries. A Model-Driven Approach
摘要:
最近,我们提出了一种模型驱动的方法,用于在执行SQL查询时实施细粒度访问控制(FGAC)策略。更具体地说,我们定义了一个函数SecQuery(),给定一个FGAC策略S和一个SQL选择语句q,它生成一个SQL存储过程SecQuery(S,q),使得:如果具有角色r的用户u根据S被授权基于数据库的当前状态执行q,则调用SecQuery(S,q)(u,r)返回与u执行q时相同的结果;否则,根据S,如果用户u未被授权基于数据库的当前状态执行q,则调用SecQuery(S,q)(u,r)发出错误信号。毫不奇怪,执行查询q比调用相应的存储过程SecQuery(S,q)花费更少的时间。在这里,我们提出了一个基于模型的方法,用于优化由函数SecQuery()生成的存储过程。这个想法是消除SecQuery()生成的存储过程主体中的授权检查,当它们被证明是不必要的时候。基于我们之前从对象约束语言(OCL)到多排序一阶逻辑的映射,我们可以尝试使用SMT求解器来证明授权检查是不必要的。我们包括一个案例研究来说明和显示我们的方法的适用性。
英文摘要:
Recently, we have proposed a model-driven approach for enforcing fine-grained access control (FGAC) policies when executing SQL queries. More concretely, we have defined a function SecQuery() that, given an FGAC policy S and a SQL select-statement q, generates a SQL stored-procedure SecQuery(S, q), such that: if a user u with role r is authorised, according to S, to execute q based on the current state of the database, then calling SecQuery(S, q)(u, r) returns the same result as when u executes q; otherwise, if the user u is not authorised, according to S, to execute q based on the current state of the database, then calling SecQuery(S, q)(u, r) signals an error. Not surprisingly, executing the query q takes less time than calling the corresponding stored-procedure SecQuery(S, q). Here we propose a model-based methodology for optimising the stored-procedures generated by the function SecQuery(). The idea is to eliminate authorisation checks in the body of the stored-procedures generated by SecQuery(), when they can be proved to be unnecessary. Based on our previous mapping from the Object Constraint Language (OCL) to many-sorted first-order logic, we can attempt to prove that authorisation checks are unnecessary by using SMT solvers. We include a case study to illustrate and show the applicability of our methodology.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。