topic Re: section access_doubt in QlikView

section access_doubt

Fri, 08 May 2015 14:38:12 GMT

Hello Viewers,

I've doubt on section access

In section access I've create user1,user2,user3 to restrict the row level as per below

I have fields Region,Country,Year(2000-2014)

for user1-Region,Country and Year only 2000-2002 data

for user2-Region,Country and Year only 2003-2005 data

for user3-Region,Country and Year only 2006-2014 data

Section access can be of various types like

ACCESS,USERID,PASSWORD,SERIAL,NTNAME,NTDOMAINSID,NTSID,OMIT

Section access is defined as part of the load script

As per above to restrict the data with row level we have 6 fields like

ACCESS,USERID,PASSWORD,REGION,COUNTRY,YEAR

Here Access is default

How many fields we can add with in the load script initially and how can ristrict as per above?

PLZ Help me out inthis!!!

Re: section access_doubt

awhitfield — Fri, 08 May 2015 14:58:48 GMT

HI Babi,

Which fields do you want to apply the restrictions to?

Andy

Re: section access_doubt

buzzy996 — Fri, 08 May 2015 15:32:44 GMT

see tis example,

Section Access;
Load * Inline
[ACCESS,USERID,PASSWORD,REGION
ADMIN,A,X,
USER,U1,Y1,AFRICA
USER,U2,Y2,AMERICA
USER,U3,Y3,ASIA
USER,U4,Y4,EUROPE
USER,U5,Y5,*];

Section Application;
SALES:
LOAD * INLINE [
REGION, PROFIT
AFRICA, 1000
AMERICA, 2000
ASIA, 3000
EUROPE, 4000
OCEANIA, 5000
];

Re: section access_doubt

Fri, 08 May 2015 18:16:32 GMT

Region & Country & Year

Re: section access_doubt

maxgro — Fri, 08 May 2015 18:42:20 GMT

for section access wth more than one field, you can find help here

Basics for complex authorization