topic SECTION ACCESS OMIT PROBLEM in QlikView

SECTION ACCESS OMIT PROBLEM

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to omit some regions for few people, remaining users need to access all.

Kindly modify below code for that i am using ntname without password

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, LINK

ADMIN, *******\*****,

USER, ********\******,DEVP

USER, *****\*******, BI_MANG

USER, ********\******,UAT_TEST

];

Section Application;

LOAD * INLINE [

LINK, REGION

DEVP, KARNATAKA

UAT_TEST, TELANGANA

BI_MANG, KERALA

];

Re: SECTION ACCESS OMIT PROBLEM

sdmech81 — Mon, 06 Feb 2017 07:39:26 GMT

HI,

Add * fro admin in link column so that all regions are available for him.

Plss try this sample script by Stephen which give clarity:

Section Access;

LOAD * INLINE [

ACCESS, USERID, LINKFIELD

ADMIN, ADMIN, *

USER, England, E

USER, Ireland, I

USER, Scotland, S

USER, Wales, W

];

Section Application;

SecurityLink:

Load * Inline [

LINKFIELD, Country

E,England

I,Ireland

S,Scotland

W,Wales

];

Load * Inline [

Country,Sales

England,100

Ireland,99

Scotland,98

Wales,97

];

Re: SECTION ACCESS OMIT PROBLEM

maxgro — Mon, 06 Feb 2017 07:42:11 GMT

In Section Access you define the data you can view, not the data (regions) you cannot view

The omit in section access is used to remove fields, not data

This is an example; I used userid and password instead of ntname

I added an ALL link value for all regions

I added a 2REGIONS value for 2 regions

REGIONS:

load * Inline [

REGION

KARNATAKA

TELANGANA

KERALA

REG1

REG2

];

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, LINK

ADMIN, U1, U1,

USER, U2, U2, DEVP

USER, U3, U3, BI_MANG

USER, U4, U4, UAT_TEST

USER, U5, U5, ALL

USER, U6, U6, 2REGIONS

];

Section Application;

LOAD * INLINE [

LINK, REGION

DEVP, KARNATAKA

UAT_TEST, TELANGANA

BI_MANG, KERALA

2REGIONS, REG1

2REGIONS, REG2

];

LOAD

'ALL' as LINK,

REGION

Resident REGIONS;

More on section access here

Section Access

Re: SECTION ACCESS OMIT PROBLEM

Mon, 06 Feb 2017 10:12:54 GMT

Hi Vijay,

In order to omit fields for a particular user, use OMIT keyword in section access

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, LINK,REGION

ADMIN, MALABARGROUP\rchand,* //will be able to view all the listed fields

USER, MALABARGROUP\vvijay,DEVP,KARNATAKA

USER, MALABARGROUP\qlikadmin, BI_MANG,KERALA

USER, MALABARGROUP\knishanth,UAT_TEST,TELANGANA

];

Section Application;

LOAD * INLINE [

LINK, REGION

DEVP, KARNATAKA

UAT_TEST, TELANGANA

BI_MANG, KERALA

];

Here ADMIN will be able to view all regions(* means listed values).[Even if * is not given to ADMIN ,he will be able to see all the fields as his access being ADMIN ]Where as DEVP(access being user) can view only KARNATAKA,UAT_TEST for TELANGANA and BI_MANG for KERALA. If you want DEVP to view KERALA also then add

USER, MALABARGROUP\vvijay,DEVP,KERALA in SECTION ACCESS .Same applies with other users

Re: SECTION ACCESS OMIT PROBLEM

MK9885 — Mon, 06 Feb 2017 18:21:08 GMT

Star is *;

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, LINK,REGION

ADMIN, MALABARGROUP\rchand, *,*

USER, MALABARGROUP\vvijay,DEVP,KARNATAKA

USER, MALABARGROUP\qlikadmin, BI_MANG,KERALA

USER, MALABARGROUP\knishanth,UAT_TEST,TELANGANA

ADMIN, SERVICEACCOUNT\QMC,*,*

];

SA:

LOAD * INLINE [

LINK, REGION

DEVP, KARNATAKA

UAT_TEST, TELANGANA

BI_MANG, KERALA

RChand,*

];

Section Application;

Try the above script, it should work.

What it does is

rchand is an ADMIN and will have access to 3 Regions, while other users will be only limited to their designated regions.

You must have 'Star is *;' included in script which would mean as TOTAL. So whosoever has * for their field, they will have full access to that field.

To verify if the Star is *; working for you, add SA table after Section Application and you'll see RChand having 'Total' as a value when * is assigned.

//For testing

Star is *;

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, LINK,REGION

ADMIN, MALABARGROUP\rchand, *,*

USER, MALABARGROUP\vvijay,DEVP,KARNATAKA

USER, MALABARGROUP\qlikadmin, BI_MANG,KERALA

USER, MALABARGROUP\knishanth,UAT_TEST,TELANGANA

ADMIN, SERVICEACCOUNT\QMC,*,*

];

SA:

LOAD * INLINE [

LINK, REGION

DEVP, KARNATAKA

UAT_TEST, TELANGANA

BI_MANG, KERALA

RChand,*

];

Section Application;

SAS:

LOAD * INLINE [

LINK, REGION

DEVP, KARNATAKA

UAT_TEST, TELANGANA

BI_MANG, KERALA

RChand,*

];

And include your Inline load within Section Application plus also include your service account. You'd need Service account to run this script in QMC or it will fail. Service Account will be the Admin for QMC.

Re: SECTION ACCESS OMIT PROBLEM

Fri, 17 Feb 2017 06:12:26 GMT

Hi Plz use OMIT field in SectionAccess

Re: SECTION ACCESS OMIT PROBLEM

Fri, 17 Feb 2017 06:44:44 GMT

Kindly delete ur reply in this chain ....

Re: SECTION ACCESS OMIT PROBLEM

Fri, 17 Feb 2017 06:45:03 GMT

Kindly delete ur reply in this chain ....