Sheet level access based on SQL

Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: Sheet level access based on SQL

b_garside — Tue, 07 Jun 2016 15:53:23 GMT

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.