Governance Dashboard and section access

[shayraber]

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?

[migueldelval]

Hi Shay,

Rqad this document, I think that it can help you

Sheets Security with Section Access

Regards

Miguel del Valle

[Peter_Cammaert · Accepted solution]

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

[shayraber]

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