Hi, My situation is like this. I have a data extract document that runs on the client site and gets ftped into our local server which is binary loaded into the application qvw. Now i want to implement the Section Access Reduction in this application document. The original qvw doesn't have any section access.
BINARY a.qvw; //Loads the customer data extracted on their server.
SECTION ACCESS;
Directory;
LOAD ACCESS,
NTNAME,
XX
FROM
Security\ControlSheet-POS.xlsx
(ooxml, embedded labels, table is Sheet1);
load * inline
[
XX, Domain
Domain1, Domain1
Domain2, Domain2
Domain3, Domain3
];
Now the excel file is something like this.
ACCESS
NTNAME
XX
ADMIN
User1
Domain1
With this data, I login as User1 and expect to see only the data for Domain1, but I get to see all the data. Whatever I have done is not working. Domain is a column name in the original data model in a.qvw file.
Hi treseco, Thanks for all your help. I have modified according to what you said. But it doesn't seem to work at all. Once I set this up with Strict exclusion, I get an access denied. I have attached the files without a Strict exclusion here. Please see what I do wrong.
Sorry, i could not check your file for obvious reason, NTNAME checks the windows id for authentication and there i fail to open your file. And yes, i checked with my domain/id information in the sample file and it worked fine to filter region. i would suggest you to try various options like, load the section access data INLINE(use all data in capitals) and test if it is working. Narrow down the issue area and finally you would be able to get it done.
