i have used below script to build Section Access, based on SID i want to filter the data(the field on which i want to restrict data). After building the section access, i am unable to open the application it is asking user name and Password. without username and password i want to restrict the data based on OSUSER(). kindly help me
Data: LOAD SID
FROM [C:\Desktop\Section Access\ Output.xlsx] (ooxml, embedded labels, table is Sheet1);
You can use the following link to search the 'Documents' others have written on Section Access too, just search on Section Access in the search box there, there are quite a few that should provide further information:
That all being said, unless you have multiple domains in play, you really just need the NTNAME field, you do not need the SID fields, those are really only going to be necessary if you could potentially have duplicate users across domains...
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.