Multi-tenant Database Access Control

Storing data in the cloud is a new multi-tenant database solution that has recently emerged to deliver database for multiple users, who can store and access their data over the internet. This multi-tenant database designed to be used by multiple tenants and each tenant may have multiple users. Therefore, this database type demands a special multi-tenant access control model, which provides an access control not only for multiple tenants, but also for multiple users per tenant. In this paper, we are proposing a multi-tenant access control model based on a multi-tenant database schema called Elastic Extension Tables (EET). In this model, we define access control data architecture, and the EET access grants which can be granted to tenants´ users. Moreover, we propose an access control algorithm, which allows users to access the data granted to them based on a number of groups or roles assigned to these users.