Hello, I am trying to implement section access and having a hard time getting anything to work the way I want.
I've used it in the past on a regular server (without publisher) and without a binary load; I am wondering if these are having some interaction with my document (I can't really test this as I have no choice but to work from a binary load and do not have admin rights on the server/publisher).
Do Publisher rights take precedence over section access right? I am actually TRYING to lock myself out of the document via section access (yes I have a backup) but it just keeps letting me open it, even if I don't have myself listed as a user anywhere in section access.
And then when I add myself and try to do data reduction on a column it simply does nothing. Nothing at all. (I have checked data reduction based on section access/strict exclusion/prohibit binary)
I know that in section access the main fields have to be in all caps, but what about the field I want to do data reduction on? It's not caps in the rest of the application so putting it in caps here would not work unless I change it everywhere else too. Is this required?
Do all NTNAME entries have to be all caps?
Any tips here? I would love to provide an example but the data is quite confidential... however if someone wants to help me troubleshoot I will provide what information I can.
two follow-up questions now that the section access is working:
If I want a user to have access to all the values in the field that I am reducing the data on I thought I could just leave the cell blank? this is not working; it denies me access when I leave it blank
Secondly, the field that I am reducing data on is stand alone table separate from the rest of the data model; I have some users that should have ZERO access to this stand alone table but full access to the rest of the application. What is the best way to achieve this?
A simple way to achieve this is to add a dummy region value (e.g. 'NONE', or 'NOREGION', or whatever you prefer) to both section access and section application. You can use something like this in section application: concatenate (<your stand alone table name>) load 'NONE' as REGION autogenerate 1;
So the new record has only additional value for REGION and nothing for other fields.
In a scenario like this when you use * it means everything thats explicitly mentioned in the table. So the Admin will see only US,AUS,UK. For him to view all you have to do
Section Access:
Load * inline[
ACCESS,NTNAME,REGION
Admin, A1234, *
Admin,A1234,CAD
Admin,A1234,MEX
User,A782,US
User,A9024,AUS
User,A8888,UK
];
or if some other user has those two regions assigned to them then just * for admin will work.
For users to not be able to view that table at all you can use omit for all the fields in that table.
Please go through the attached doc. Its very informative.
