2 Replies Latest reply: Mar 26, 2013 3:25 AM by Martin Vierling RSS

    Independent Section Access on associated tables?



      please see the attached file:

      assuming I have a data model which contains e.g. three dimension tables with their own primary key. attached to each of the table there is an access table which contains the ids/names of users which have access to the records of the dimension.


      One example might be the table "Firma":

      - User 1 has access to Firma 1 and 2

      - User 2 has access to Firma 1 and 3

      - User 3 has access to Firma 3


      Similar for the other tables. What do I need to do to make sure that each user (when he opens the document) has access only to the records of each dimension where he is supposed to? Important is that the access to the dimensions can be independent... that means a user can have access to Firma1 but might have access only to one or two of its associated records called Kontakt. Or he has access to all records called VKC but not the associated Firma. Is clear what I mean?


      I am struggling with the creation of the section access table... can I grant access independently to records which are associated by the data model?


      If this is not clear let me know. :-) Help would be great...