Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have a governance dashboard with additional script appended.
I'm also doing some customizations in the UI.
I want to have the document accessible through the access point and want to restrict the document to several users only.
couldn't find a way of doing it with section access.
any idae?
Actually this is pretty simple (you're only talking about "restrict the document to several users only", not about hiding/showing sheets or reducing data). Sine the entire load script of the GD is already stored in a hidden script, add something like this to the script (anywhere will do, as long as it is in the main body):
:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, YourDomain\ServiceAccountname
ADMIN, YourDomain\YourUsername
USER, YourDomain\OtherUserAccount
];
Section Application;
:
Replace the parts in italics with values that apply to your environment, save and reload. From now on, section access controls access to this document.
IMPORTANT: make sure that you keep a copy with the Section Access-statement commented out at all times. For those situations where you cannot access your own document anymore.
Best,
Peter
Hi Shay,
Rqad this document, I think that it can help you
Sheets Security with Section Access
Regards
Miguel del Valle
Actually this is pretty simple (you're only talking about "restrict the document to several users only", not about hiding/showing sheets or reducing data). Sine the entire load script of the GD is already stored in a hidden script, add something like this to the script (anywhere will do, as long as it is in the main body):
:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, YourDomain\ServiceAccountname
ADMIN, YourDomain\YourUsername
USER, YourDomain\OtherUserAccount
];
Section Application;
:
Replace the parts in italics with values that apply to your environment, save and reload. From now on, section access controls access to this document.
IMPORTANT: make sure that you keep a copy with the Section Access-statement commented out at all times. For those situations where you cannot access your own document anymore.
Best,
Peter
pologize...
apparently, I handled it myself.
first, I didn't notice that I can view the hidden script (that's why I thought that I can only add script at the end and not at the beginning) so I can add a regular section access script.
in addition, even without revealing the script - adding a section access via the wizard - worked!
so thanks everyone