I have the usual situation wherein I am creating projects to represent different labs, but I need to expose ALL of the underlying labs' data to an over-arching Admin role (without the admin having to navigate into the separate projects).

- main project (Admin)
  - lab1
  - lab2
  - lab3

I've been experimenting with the Demo module and have exposed the Person table via registerProvider, so that the labs can access and manipulate the data via JavaScript, but I need some help to expand on that.

I want to maintain the current security level for the labs (so they can only access and modify their data), but expose ALL of the data to an Administrative role where the data can be viewed and modified via JavaScript.

Any suggestions on how to set up this schema or examples in other modules would be most welcome.

Many thanks,

bront


e.g.,
DefaultSchema.registerProvider("demo", new DefaultSchema.SchemaProvider(this)
        {
            public QuerySchema createSchema(final DefaultSchema schema, Module module)
            {
                DbSchema dbSchema = DbSchema.get("demo");
                return QueryService.get().createSimpleUserSchema(dbSchema.getQuerySchemaName(), null, schema.getUser(), schema.getContainer(), dbSchema);
            }
        });