Section Access Issue Sheet level security

[kakani87]

Hi Everyone .... here i'm not able to implement sectuion access sheet level

Reqirement is to restrict admin both SH1 and SH2  to access, ajith only SH1 and Sai only SH2

When user is logged as 'Sai' then it is not restricting accordingly

Following is my script and Attachment of File as well so do me favour in implementing this successfully.

USER, AJITH, 123

USER, SAI, 123

ADMIN, ADMIN, 123

SECTION Access;

ACCESS:

load * Inline

[

ACCESS, USERID, PASSWORD, EMPCODE

USER, AJITH, 123, 1

USER, SAI, 123, 2

ADMIN, ADMIN, 123, *

];

SECTION Application;

EMPMST:

LOAD * Inline

[

EMPCODE,EMPNAME

1,AJITH

2,SAI

3,ADMIN

];

TAB_ACCESS:

load * Inline

[

EMPCODE,TAB1,TAB2

1,1,0

2,0,1

]

;

SALE:

load * Inline

[

EMPCODE,QTY,VALUE

1,10,100

1,2,20

2,1,10

2,2,20

];

!

[jaumecf23]

I have attached a pdf document that can help you.

[stigchel · Accepted solution]

There is a setting in the document properties you need to deselect, see attached qvw that does hide the sheets...

[passionate]

Hi Kakani,

instead of using tabaccess use conditional hide and show in sheets.

PFA.

Please let me know for more information.

Cheers,

Panka

[kakani87]

Hi Piet .... this worked thank you very much

[kakani87]

Hi Pankaj ... Thank you for the work done by you

After making change in conditional as =TAB1 and =TAB2 this as well working fine .

[kakani87]

Piet and Pankaj let me thank you both for resolving this issue