Section Access; LOAD upper(ACCESS) as ACCESS, upper(NTNAME) as NTNAME, upper(GROUP) as GROUP FROM 'E:\Dev\Security\Users.xls' (biff, embedded labels, table is [Users$]); Section Application;
Load GROUP,[X-MEDIA], [X-SEM] FROM 'E:\Dev\Security\Groups.xls' (biff, embedded labels, table is [Groups$]);
On load I get:
Users$ 14 lines fetched Groups$ 11 lines fetched
But I cannot use the table Users$ nor view it in the table viewer (I can use the table Groups$).
Data loaded in section access can not be seen in your application, its only used to determine what users are able to access the application at User/Admin level.
It is possible to create a connection between section access and section application through the "Initial Data Reduction Based on Section Access" which makes it possible to limit what data a certain user can see.