A Flexible Database Authorization System

In this paper we present an authorization mechanism for a relational database. It allows defining the user privileges exact to a table row. To implement that we used the INSTEAD triggers installed on views. This authorization system is an interesting application of such triggers. The user privileges are organized into parameterized roles that can be instantiated and/or inherited by other roles. Key Words database security, role, privilege, view, INSTEAD trigger

• Type: Conference
• Year: 2004
• Where: DBA
• Authors: Bazyli Blicharski, Krzysztof Stencel
• Keywords: Authorization Mechanism, Database, DBA 2004, Relational Database, User Privileges