This sample application demostrates the usage of single database multi-tenancy component for CUBA.Platform.

This application contains tenant-specic entity Store and some system entities that came along with CUBA have been made tenant-specific: users, security subsystem (groups, roles), filters, user sessions.

This application also contains sample data: two tenants, tenant admins, tenant user, access group hierarchy, tenant-specific security role, application data (created by tenant users), tenant-specific filter.

Each tenant was given it's own admin, who is able to create users, set up roles, permissions, and access groups.

The following users are created:

Tenants, created by a global admin:

Users visible to global admin:

Tenant users, created by and visible to tenant admin:

The application showcases creating an access groups hierarchy: different tenants having freedom of setting up their own access groups:

Tenant-specific application data (Stores), accessible to respective users (second screenshow also showcases a filter created by tenant user):

Note that global admin can see which teant the records belong to (first column).

Tenant admins are able to view user sessions from administration menu. The list of user sessions is limited to their own users.

Entity Store is created like normal persistent entity, but extended from StandardTenantEntity, instead of StandardEntity:

@NamePattern("%s|name")
@Table(name = "SDBMTSAMPLE_STORE")
@Entity(name = "sdbmtsample$Store")
public class Store extends StandardTenantEntity {
    private static final long serialVersionUID = 4530286659914776459L;

    @Column(name = "NAME")
    protected String name;

    @Column(name = "ADDRESS")
    protected String address;

    public void setName(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getAddress() {
        return address;
    }
}

Another way of making tenant-specific entity is to implement HasTenant interface manually. This can be useful if entity is system-level, or it doesn't need all of the attributes of StandardEntity.

System level entities in the application are made tenant-specific using this method:

@Extends(User.class)
@DiscriminatorValue("EXT")
@Entity(name = "sdbmtsample$ExtUser")
public class ExtUser extends User implements HasTenant {
    private static final long serialVersionUID = -2598354095282194816L;

    @TenantId
    @Column(name = "TENANT_ID")
    protected String tenantId;

    public void setTenantId(String tenantId) {
        this.tenantId = tenantId;
    }

    public String getTenantId() {
        return tenantId;
    }
}

Annotation @TenantId on the tenantId attribute is used by the application component to specify precisely which attribute tenants should not see anywhere in the system (including UI).