Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Do we really need to add 'ACCESS' column with defined role (ADMIN or USER) in Section Access Script. If I do not mention this the what default role does it take?
Because In one of our dashboard script is written as below:
SECTION ACCESS;
Sec1:
REPLACE LOAD * ;
SQL SELECT DISTINCT UPPER(Col1) AS 'NTNAME', UPPER(Col2) as 'Col2'
FROM MyTable;
SECTION APPLICATION;
Can you please explain me what this doing?
Thanks
Vijay Sahu
No, it means the users are identified by their credentials in the system (either Windows AD or whatever security directory you are using), instead of being prompted for a username and a password.
The ACCESS field is complementary to those.
You must.
As for the script, it creates a section access table with the account name of the user in the form DIRECTORY\USERNAME and COL2 which I guess is a field to reduce which data set can each user see.
Thanks Miguel..
But my existing dashboard has a code written mentioned above and this dashboard is running on PROD. I am not clear what this code is populating then. Is this code incorrect?
Thanks
Vijay Sahu
Yes this is has a data in form of DIRECTORY\USERNAME for 'NTNAME'. Does it mean that do not need to mention ACCESS type.
I can also see under Document properties --> Opening --> Intial Data reduction based on section access and strict exclusion are checked.
Thanks
Vijay Sahu
You can lock yourself out of the application if there are no ADMIN defined. Add that column for all ADMINs and USER for the rest.
No, it means the users are identified by their credentials in the system (either Windows AD or whatever security directory you are using), instead of being prompted for a username and a password.
The ACCESS field is complementary to those.
Thank you very much. Its clear now.. This Section Access has script after SECTION APPLICATION which is again populating data form some tables which are link to COL2 mention in Section Access Script part.
Now I am getting it. Thank you very much.
You are most welcome.
That is correct. Section Access however can be used at any point in the script, all what matters is that the fields are following the conventions (e.g.: field names and field values all UPPERCASE) and when the user logs in, the record with his username is checked for a reduction and applied.
It behaves the same as if you click on a username and go to File > Reduce Data > Keep Possible Values