Need help in providing sheet level section access through section access mangement

[#1]

Hi all,

Need help in providing sheet level section access through section access mangement

plz provide steps to follow

Thanks

Sudhanshu shrivas

[#2]

Hi Sudhanshu,

It is possible, find below an example how the section access should look like,

Section Access;

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.

Regards,

Sajeevan

[#3]

hi,

thanks for your reply

I need to do this through section access management tab of qv server.

as I will be taking the link of auth table to generate my section access.

need to know how I can give sheet level section access using servers section access management tab.

thanks

[#4 · Accepted solution]

I think this can only be done through the document section access

[#5]

Hi all,

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

Thanks

Sudhanshu Shrivas

[Anonymous]

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 Govindan 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.

[#7]

Hi,

Thanks for your reply.

I did as you advise and it works now.

sheet level section access cant be given through section access management tab.

applied section access using another excel.

Thanks

Sudhanshu Shrivas