Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've the below code in order to give access to the users at the sheet level.
SECTION Access;
LOAD * INLINE [
ACCESS, NTNAME, USER
ADMIN, XYZ\USER, A
USER, XYZ\USER, B
];
SECTION Application;
LOAD * INLINE [
USER, SH01, SH02
A,1,1
B,1,0
];
Apart from the above code do I've to give any kind of conditions at the sheet level in order to have the code worked?
Regards,
Vikas
can some one help me on my request please.
try to read this
there are 5 lin to sheet security with section access
also this can help you
Thanks for the links, I've tried the below code in order to give access to users for particular sheets.
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, NAME
ADMIN, XYZ\1, A
USER, XYZ\2, B
];
Section Application;
LOAD * INLINE [
NAME,SHEET
A, 1
B, 2
];
Security_Ref:
LOAD * INLINE [
SHEET, ATM, Windows Server, ATM Checks
1, 1, 1, 1
2, 1, 1, 0
];
As you can see I gave user B access to only ATM and Windows Server sheets when ever I publish User A can able to see all the sheets (ATM, Windows Server, ATM Checks) but user B is facing below.
I've checked Initial reduction in the settings and enabled the conditions at the sheet level as below.
=if(ATM=1,1,0)
=if(Windows Server=1,1,0)
=if(ATM Checks=1,1,0)
but still user B not able to open the document.