How to use user passwords with auto(locked) filters

[#1]

Hey guys

How can I manage to protect whe qvw file with user/password like:

And using that, how can i lock selection by users? (using table with same user, but, how to link?)

Example: User A can only see department XZY

[vishsaggi · Accepted solution]

You have to implement section access in your QVW. Follow some links here:

Section Access Loading from SQL  

Mapping table with Section Access

Section Access

Sheets Security with Section Access