Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I dont want one of my user to access certain sheets in my qvw file. I used section access for different user, but i dont know how to hide sheets for different user.
When a user logs in using userid and pwd, some sheets should be hidden.
Regards
Ranjit
Hi,
Hope this will help you.
Thanks & Regards
Thank you upendra
I am unable to unrar your file.
You could create a field in your users table, something like ShowTabs. Everyone would have a 1 there, except the user in question.
Since your Security Table will not be available after Section Access is used, I would reload the contents of your Security table into another table and Qualify it.
Something like:
SecurityTable:
Load ...
Qualify *;
AccessTable:
Load * Resident SecurityTable;
Unqualify *;
Then on your charts Conditional Show, use: AccessTable.ShowTabs = 1.
Thanks! This is helpful!
an example in my attachment here
Use this code in script where 1 show page and 0 hide page
REPLACE LOAD * INLINE [
USER, PAGE01, PAGE02, PAGE03, PAGE04
XXXXX, 1, 1, 1, 1
USERID, 1, 1, 1, 0