Can you perform section access for tabs? So if I was authenticating users by their AD login information, can I say what tabs within a document they can see?
The 'X' is an arbitrary character I put to define that the user has access to the particular tab, you must define all the access in the script. If you want to get it back you can access the sheet properties through the document properties and clean the expression.
is a field matching the sheet and it will change between the tabs. i.e. if you have a sheet called Dashboard and another called Analysis you may have 2 different columns in your access table like "Dashboard" and "Analysis" and the conditional shown expressions will be Only(Dashboard) = 'X' and Only(Analysis) = 'X'
Ok, first of all you need a common field between the Section Access and the Section Application... this way you can use the configuration "Initial Data Reduction based on Section Access", the field could be the NTNAME for example. In the Section Application you'll have your access table, so the script may look like this:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, JOHN.DOE
USER. JANE.DOE
USER. JOE.SMITH
];
Section Application;
ACCESS:
LOAD * INLINE [
NTNAME, APPLICATIONS,USER,MANAGER
JOHN.DOE,X,X,X
JANE.DOE,X,X,
JOE.SMITH,,,X
];
Finally, you put the expressions on the sheets show conditions:
Only(APPLICATIONS)='X' , Only(USER)='X' and Only(MANAGER)='X'
Isnt there an inherit problem with this though. Cant the user go in and remove the conditional statement? Or is there a setting on the document properties to not allow them to see the tab properties?
If the user has access to change the sheet properties it can disable the hide conditions. You can disable the Sheet Properties for users in the Document Properties / Security tab.
