A Fine Grained Access Control Model for Relational Databases
Nowadays most of the commercial work make use of Relational DataBase Management Systems (RDBMS) to store a substantial amount of their data. Accessing information over the Internet has become an essential requirement. Authorization mechanisms in SQL permit access control at the level of complete tables or columns, or on views, providing coarse granularity. There is no direct way to control which tuples can be accessed by which users. Fine Grained Access Control (FGAC) is one of the ways to ensure data security. As per the requirements the granularity of fine grained access control can be on directories or folder level, database level, table level, even on individual record (tuple) and data field level.