It is possible, find below an example how the section access should look like,
LOAD * INLINE [
NTNAME, ACCESS, USERID, PASSWORD, DEPARTMENT, SHEETS1, SHEETS2
XX, USER, *, *, DEPARTMENT1, 1, 0
XX, USER, *, *, DEPARTMENT2, 0, 1
In sheet properties, make the Show Sheet as conditional with the condition as sum(SHEETS1)=1 for those who need to see the sheet1, and son on.
I have section access through section access management tab of server.
I am planning to create a excel for sheet level access an add it to the script of my doc under the place where I have taken section access auth file.
Hope this works
any other suggestions will be helpful
The Section Access Management tab in the QMC is merely a way of storing the data needed for Section Access, so you can use it store the data that sajeevan has suggested earlier in his Inline Load. You can then simply load it from the url in the script.
Then do what he suggested for the conditional Show Sheet.