section access_doubt

[#1]

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!!!

[awhitfield]

HI Babi,

Which fields do you want to apply the restrictions to?

Andy

[buzzy996]

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
];

[#4]

Region & Country & Year

[maxgro]

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

Basics for complex authorization