Record Details


Field	Value

Title	Extending query rewriting techniques for fine-grained access control

Names	RIZVI, SHARIQ MENDELZON, ALBERTO SUDARSHAN, S ROY, PRASAN
Date Issued	2004 (iso8601)
Abstract	Current day database applications, with large numbers of users, require fine-grained access control mechanisms, at the level of individual tuples, not just entire relations/views, to control which parts of the data can be accessed by each user. Fine-grained access control is often enforced in the application code, which has numerous drawbacks; these can be avoided by specifying/enforcing access control at the database level. We present a novel fine-grained access control model based on authorization views that allows "authorization-transparent" querying; that is, user queries can be phrased in terms of the database relations, and are valid if they can be answered using only the information contained in these authorization views. We extend earlier work on authorization-transparent querying by introducing a new notion of validity, conditional validity. We give a powerful set of inference rules to check for query validity. We demonstrate the practicality of our techniques by describing how an existing query optimizer can be extended to perform access control checks by incorporating these inference rules.
Topic	Query Processing
Identifier	Proceedings of the ACM SIGMOD International Conference on Management of Data, (SIGMOD), Paris, France, 13-18 June 2004, 551-562

ICAR Research Data Repository for Knowledge Management