Sheet level access

[jagan]

Hi,

This document helps in implementing Sheet level access based on the user using Section Access.  I configured four users A, B, C and D and no password is required to login.

If you login as A, then you can see both Sheet1 and Sheet2.

If you login as B, then you can see only Sheet1.

If you login as C, then you can see only Sheet2.

If you login as D, then you can see both Sheet1 and Sheet2.

The user access is defined in the table

UserID	Sheet1	Sheet2
A	1	1
B	1	0
C	0	1
D	1	1

Hope this helps others in implementing Sheet level security.

Regards,

Jagan.

[ali_hijazi]

what is the user name and password

I downloaded the document and it asks me for a userID

[Jason_Michaelides]

Judging by the filename the UserID is either A, B, C or D and no password is required...

[sergioabr_tocca]

Hi,

Give it an A.

[#5]

Hi,

How can i add a prompt message to say to the user when has no access ?

Thanks

[jagan]

There is no such option if you use section access, you can implement this manually, on Document Open trigger get current user and validate the user identity, if it is valid redirect to the Dashboard sheet otherwise show error message.

[#7]

Hi all

can anyone please help me, why here i am unable login with user B and C. but i am able to login with A and D

Thank you

[sunny_talwar]

Not sure why, but after reloading the application, the login for B and C start working again.

[#9]

oh gr8 yeah, after reloading it is working.

the funny thing is even my document was not loading with users , and it worked now after reloading now. but, i have reloaded it several times before, but its working now only.

[#10]

Hi,

could you please look at it, if you can

Unable to login as User after implementing section access

[#11]

Thanks for sharing . Good post