Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ntname in the section of access

I'm using ntname in the section of access but it does not work:

Syntax.:
Access Ntname division id
01 user rolandog

table division
division id description
01 bird-
02 food

use in above script and it does not work and also activates the initial reduction option based data access section.

please help

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Rolando,

That is correct. the "*" sign in the section access doesn't mean "all possible values" but "all values listed in section access". In this case, indeed, the only value for DIVISIONID is 01, so the "*" equals to 01.

Now it depends on the environment you are using. If you are using QlikView Server, then you will need to add each possible value (even if they are thousands) to the section access list for one user, so the "*" has the proper meaning of "all values",

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
ADMIN, GRUPOMELO \ JUANA, 01

ADMIN, GRUPOMELO \ JUANA, 02

ADMIN, GRUPOMELO \ JUANA, 03

ADMIN, GRUPOMELO \ JUANA, 04

ADMIN, GRUPOMELO \ JUANA, 05

ADMIN, GRUPOMELO \ FMK, *
USER, GRUPOMELO \ AIDAR, 01
ADMIN, GRUPOMELO \ ROLANDOG, *
];


SECTION APPLICATION;

Now users JUANA, FMK and ROLANDOG will see records related to DIVISIONID 01, 02, 03, 04 and 05. You can use either a different field instead of DIVISIONID, some field that aggregates several possible values (GroupID, DivisionGroup or something like that).

But if you are using QlikView Desktop instead of QlikView Server (you don't have QlikView Server) then just leave field DIVISIONID blank instead of using the "*" sign. Then those users will have see all values of that field.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

View solution in original post

9 Replies
Not applicable
Author

Please make sure that SECTION ACCESS is in uppercase.

I think, in your syntax fields should be interchanged. ACCESS is 01?

Kiran.

Not applicable
Author

Corrected:
Syntax.:
SECTION ACCESS;
LOAD * INLINE [
Access, Ntname, division id
USER, rolandog, 01
];

APPLICATION SECTION;

division table:
LOAD
division id, description
01, bird-
02, food

SELECT * FROM DIVISION

please help

Miguel_Angel_Baeyens

Hi Rolando,

Fields must be uppercase in all tables within and out of the section access part, as Kiran says. Check the script in the attached application.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

THANKS FOR THE HELP

With the following script, ME LIMITED TO ALL USERS TO DIVISION 01.
USERS JUANA, FMK, ROLANDOG should have access to everything, but does not work.

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
ADMIN, GRUPOMELO \ JUANA, *
ADMIN, GRUPOMELO \ FMK, *
USER, GRUPOMELO \ AIDAR, 01
ADMIN, GRUPOMELO \ ROLANDOG, *
];


SECTION APPLICATION;

Miguel_Angel_Baeyens

Hi Rolando,

That is correct. the "*" sign in the section access doesn't mean "all possible values" but "all values listed in section access". In this case, indeed, the only value for DIVISIONID is 01, so the "*" equals to 01.

Now it depends on the environment you are using. If you are using QlikView Server, then you will need to add each possible value (even if they are thousands) to the section access list for one user, so the "*" has the proper meaning of "all values",

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
ADMIN, GRUPOMELO \ JUANA, 01

ADMIN, GRUPOMELO \ JUANA, 02

ADMIN, GRUPOMELO \ JUANA, 03

ADMIN, GRUPOMELO \ JUANA, 04

ADMIN, GRUPOMELO \ JUANA, 05

ADMIN, GRUPOMELO \ FMK, *
USER, GRUPOMELO \ AIDAR, 01
ADMIN, GRUPOMELO \ ROLANDOG, *
];


SECTION APPLICATION;

Now users JUANA, FMK and ROLANDOG will see records related to DIVISIONID 01, 02, 03, 04 and 05. You can use either a different field instead of DIVISIONID, some field that aggregates several possible values (GroupID, DivisionGroup or something like that).

But if you are using QlikView Desktop instead of QlikView Server (you don't have QlikView Server) then just leave field DIVISIONID blank instead of using the "*" sign. Then those users will have see all values of that field.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

thanks for the help.

I am using a QlikView Server.

Rolando

Not applicable
Author

This was helpful.  First off, the all caps NTNAME of DOMAIN\USER helped, and how I load my users (via SQL scripts) have to come after the Section Access statement.

Thanks,

Jeff G

Not applicable
Author

hi,

I have a concern in section access. can u pls help?

If I have a hierarchy of users, then how am i going to achieve section access?

kkkumar82
Specialist III
Specialist III

hi,

I think you have to create a separate row for each user with the top hierarchy person or dimension value.