Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: ntname in the section of access

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

9 Replies
Not applicable

ntname in the section of access

Please make sure that SECTION ACCESS is in uppercase.

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

Kiran.

Not applicable

ntname in the section of access

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
Not applicable

Re: ntname in the section of access

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

Re: ntname in the section of access

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
Not applicable

Re: ntname in the section of access

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

Re: ntname in the section of access

thanks for the help.

I am using a QlikView Server.

Rolando

Not applicable

ntname in the section of access

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

Re: ntname in the section of access

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
Not applicable

Re: ntname in the section of access

hi,

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