Role-based administration of user-role assignment: The URA97 model and its Oracle implementation

Article type: Research Article

Authors: Sandhu, Ravi | Bhamidipati, Venkata

Affiliations: Laboratory for Information Security Technology, ISSE Department, Mail Stop 4A4, George Mason University, Fairfax, VA 22033, USA. E-mail: [email protected]

Abstract: In role-based access control (RBAC) permissions are associated with roles, and users are made members of appropriate roles thereby acquiring the roles’ permissions. The principal motivation behind RBAC is to simplify administration. An appealing possibility is to use RBAC itself to manage RBAC, to further provide administrative convenience. In this paper we investigate one aspect of RBAC administration concerning assignment of users to roles. We define a role-based administrative model, called URA97 (User-Role Assignment ’97), for this purpose and describe its implementation in the Oracle database management system. Although our model is quite different from that built into Oracle, we demonstrate how to use Oracle stored procedures to implement it.

DOI: 10.3233/JCS-1999-7404

Journal: Journal of Computer Security, vol. 7, no. 4, pp. 317-342, 1999