Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Section Access: No access type used

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

1 Solution

Accepted Solutions
Highlighted

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.

View solution in original post

8 Replies
Highlighted

You must.

  • ADMIN identifies users who can open the app using QlikView Desktop and therefore have full access to edit the file, delete objects, reload, etc.
  • USER identifies everyone else, regardless whether or not they can see all data or only a reduced set
Highlighted

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.

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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

Highlighted

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.

Highlighted

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.

View solution in original post

Highlighted
Creator
Creator

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.

Highlighted

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