Well the only option you have now is to restrict access to the UI-O-Matic section (so it's either access to all or none).

What would the permissions options be that you need, I can look into adding a simple workflow (so that on the attribute you can specify if a certain member group has access or not)

Usertypes that is not member groups, but if you sketch your scenario I'll see if it's doable

So say you have table x and table y and user john and user jane, john would only need access to table x and jane to table y, something like that? So removing an entire tree based on the logged in user? Not sure I can make something generic, but could add an event model that would allow you to remove the node based on some rules (that you can specify)

Well, we want all users to have access to the tables.

Say we have a small bookingsystem with one table only.

In that table we only want John and Jane to see "their" content. And since they are "mapped" to SiteRoot XX they will only see content with SiteRootId XX.

Does this make sense? :-)

It does :) in this case you basically want to add an additional where statement to the sql query fetching the data

Again will try to do this with an event model so it's possible to have hook into stuff like these

Shouldn't be that hard, will get that done today/tomorrow

Ok just made a couple of changes that now add an event model, you should be able to attach to the following 2 events

UIOMatic.Controllers.PetaPocoObjectController.BuildingQuery
UIOMatic.Controllers.PetaPocoObjectController.BuildedQuery

As you can see in the code here https://github.com/TimGeyssens/UIOMatic/blob/master/src/UIOMatic/Controllers/PetaPocoObjectController.cs

They should allow you to manipulate the query before it's bein executed, thus adding your additional rules :)

I'll give your scenario a go tomorrow

Ok so this is now an example

public class EventHandlerscs: ApplicationEventHandler
{
    protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
    {
        UIOMatic.Controllers.PetaPocoObjectController.BuildingQuery += PetaPocoObjectController_BuildingQuery;
    }

    void PetaPocoObjectController_BuildingQuery(object sender, UIOMatic.QueryEventArgs e)
    {
        if (e.TableName == "ccpEvent")
            e.Query.Where("AREAID = @0", 2);
    }
}

You get the gist here? You'll need to filter on your table name first and then set the where on your SiteRootId, fetching that value in some way from your user...

Worked like a charm, thanks.

Now I just have to find out a way to get the "Start Node in Content" ID from Umbraco.

Great :) thanks for confirming!

is working on a reply...