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?
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