Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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
];
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
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
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.
Hi Plz use OMIT field in SectionAccess
Kindly delete ur reply in this chain ....
Kindly delete ur reply in this chain ....