SECTION ACCESS problem

[#1]

Hi all,

I'm hoping someone may be able to help with a couple of issues I'm having with section access.

At the moment we have three levels of user and I want to add a fourth.

Current we have:

Global - access to everything
Group Leader - access to everything within a specific Department
Partner - new level
Associate - only have access to their own data

So, an example of our data might be:

NTNAME,LOGIN,DEPT,ACCESS,RANK
GLOBALUSER,*,*,User,Partner
GROUPLEADERUSER,*,1-1,User,Partner
PARTNERUSER,PARTNERUSER,1-1,User,Partner
PARTNERUSER2,PARTNERUSER2,1-1,User,Partner
ASSOCIATEUSER,ASSOCIATEUSER,1-1,User,Associate
ASSOCIATEUSER2,ASSOCIATEUSER2,1-1,User,Associate
GROUPLEADERUSER2,*,1-2,User,Partner
PARTNERUSER3,PARTNERUSER3,1-2,User,Partner
PARTNERUSER4,PARTNERUSER4,1-2,User,Partner
ASSOCIATEUSER3,ASSOCIATEUSER3,1-2,User,Associate
ASSOCIATEUSER4,ASSOCIATEUSER4,1-2,User,Associate

the way that this would work is that GLOBALUSER would be able to see data for all users.
GROUPLEADERUSER can see all data for all users in department 1-1
PARTNERUSER and PARTNERUSER2 can only see their won data within department 1-1
ASSOCIATEUSER and ASSOCIATEUSER2 can only see their won data within department 1-1
GROUPLEADERUSER2 can see all data for all users in department 1-2
PARTNERUSER3and PARTNERUSER4 can only see their won data within department 1-2
ASSOCIATEUSER3 and ASSOCIATEUSER4 can only see their won data within department 1-2

What I'm trying to achieve here is for the PARTNERUSERs to be able to see their own data and also data for the ASSOCIATEUSERS within their department. However we want them not to be able to see the other PARTNERUSERs data.

Thanks for your help,

Marcus

[gauravkhare]

Hi Marcus, we have to add another level of access and here we need to mention the sheet group. Correspondingly we need to give the sheet id for example sh01 against the user admin etc.

this will work out, kindly try....

[#3]

Hi Gaurav, thanks for the reply. Unfortunately that's not really an option given that we already have several sheets within our application, and navigation triggered by selection of a couple of fields. Duplicating sheets for different levels of user access, although technically it will allow us to achieve our ovjective, it will complicate our navigation. What I'm really looking for is a solution that is encompassed within SECTION ACCESS. Marcus