Sheet level security

[#1]

Hi All,

I want to give sheet access to the perticular departments. I put the condition for displaying the sheet.

Its working fine when I open it in Developer edition.

When I acess through client machine, It is not working. It is displaying all sheets.

Can you please help me? Thanks in advance.

Regards,

Veman Reddy

[prieper]

Can you post your script and conditions?

[boorgura]

Not sure what conditions you have put-in.

I do use some conditional showing of sheets based on the Used ID's.

we have the function OSUser() which returns "Domain\UserID"

We can use a condition like this:

=if(only(if(UserID = OsUser(), UserID)) = OsUser(), 1 ,0)

Where UserID is the field I load from an excel files. (It has the list of User IDs who need access to the corresponding TAB)

[#4]

Thanks for your reply.

Please find the details of Script and sheet display condition below.

1. The script I am using is:

LOAD * INLINE [
NAME, SH01, SH02, SH03
AAA, 1, 0, 1
BBB, 0, 1, 0
SERVER, 1, 1, 1
];

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, NTDOMAINSID, NAME
USER, INDAAA, S-1-5-21-XXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX, AAA
USER, INDBBB, S-1-5-21-XXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX, BBB
ADMIN, INDSERVER, S-1-5-21-XXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX, SERVER
];
Section Application;

2. The condition that I am using for sheet display is SUM(SH01)>=1 and SUM(SH02)>=1 and so on

[#5]

Thanks for your reply.

Please find the details of Script and sheet display condition below.

1. The script I am using is:

LOAD * INLINE [
NAME, SH01, SH02, SH03
AAA, 1, 0, 1
BBB, 0, 1, 0
SERVER, 1, 1, 1
];

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, NTDOMAINSID, NAME
USER, INDAAA, S-1-5-21-XXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX, AAA
USER, INDBBB, S-1-5-21-XXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX, BBB
ADMIN, INDSERVER, S-1-5-21-XXXXXXXXXX-XXXXXXXXXX-XXXXXXXXXX, SERVER
];
Section Application;

2. The condition that I am using for sheet display is SUM(SH01)>=1 and SUM(SH02)>=1 and so on