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.

[prasadmundewadi]

That's clear now. Thanks

[nkosinde13]

Hi All

Mine is a bit different. Sheets are activated by buttons and if the user doesn't have access they can still see the button but it will be grayed out with no actions i.e. they cannot click it to activate the sheet or perform any action.

The problem that I have is, the first button on the model is "Dashboard"and some users don't have access to it. Currently when the model is open all users land into Dashboard even if they are restricted. So how do I ensure that those users land only on the button(s) they have access to?

Thanks