Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Sheet level access based on SQL

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?

1 Reply
b_garside
Valued Contributor

Re: Sheet level access based on SQL

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

ROLEDASHBOARDMARKETSACTIVEOPPREPORTFORMTRENDSBDSALESPLANNINGADMIN
ADMIN111111111
EXECUTIVE011000000
BD001000000
OPERATIONS00
Community Browser