Title
On the Soundness Property for SQL Queries of Fine-grained Access Control in DBMSs
Abstract
The fine-grained access control approaches in DBMSs should satisfy soundness property which requires the answer of a query returned by the approach under the control of fine-grained access control is consistent with the answer when there is no fine-grained access control. However, existing techniques cannot guarantee soundness property for all SQL queries. Therefore, for an approach, there is a practical need to state that, for which kinds of SQL queries, soundness property can be guaranteed by this approach. In this paper,we present our initial e ort for this objective. We firstly proposed a new algorithm with query modification. Then,we refine, extend and enhance the theory about soundness property, and state that, for which kinds of SQL queries, the soundness property is guaranteed by the proposed algorithm.Finally, we implement the algorithm using query modification and performance evaluation has also been conducted,which indicates this approach is feasible.
Year
DOI
Venue
2009
10.1109/ICIS.2009.21
ACIS-ICIS
Keywords
Field
DocType
query modification,soundness property,fine-grained access control,new algorithm,sql query,proposed algorithm,fine-grained access control approach,initial e ort,performance evaluation,practical need,sql queries,database management systems,data security,databases,computer science,data mining,access control,satisfiability,authorisation,algebra,sql,authorization,dbms,information science
SQL,Data security,Computer science,Authorization,Information science,Database security,Query by Example,Access control,Soundness,Database
Conference
Citations 
PageRank 
References 
6
0.46
7
Authors
4
Name
Order
Citations
PageRank
Jie Shi1292.37
Hong Zhu2477.49
Ge Fu381.86
Tao Jiang42543230.12