Sheet level access based on SQL

[#1]

Hi there,

If I have table listing user with a list of roles, is there a way to pull that data in using SQLand grant sheet level access based on the roles?

[b_garside]

Yes this is possible. You just need to load your SQL data in the Section Access of load script and link it to your roles table.

This table has flags the turn on/off certain Sheets based on the role. All you need to to is link them together.

Sheets Security with Section Access

Re: Section access for Objects security based on field criteria

ROLE	DASHBOARD	MARKETS	ACTIVEOPP	REPORT	FORM	TRENDS	BDSALES	PLANNING	ADMIN
ADMIN	1	1	1	1	1	1	1	1	1
EXECUTIVE	0	1	1	0	0	0	0	0	0
BD	0	0	1	0	0	0	0	0	0
OPERATIONS	0	0