- Move Document
- Delete Document and Replies
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sheet level access
Oct 7, 2022 9:27:44 AM
Jul 25, 2013 8:51:40 AM
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.
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
what is the user name and password
I downloaded the document and it asks me for a userID
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Judging by the filename the UserID is either A, B, C or D and no password is required...
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi,
Give it an A.
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi,
How can i add a prompt message to say to the user when has no access ?
Thanks
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Not sure why, but after reloading the application, the login for B and C start working again.
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi,
could you please look at it, if you can
- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Thanks for sharing . Good post