User access data reduction based on login

Wed, 30 Nov 2011 05:24:16 GMT

Hi ,

I am trying to build user access for multiple column with followingscript. It is not working properly. If I am login as ADMINISTRATOR, It displaysonly first 3 records only (table list of FILEDSTAFF) , where as I mentioned *for all the fields.

Can anybody tell me how to get all the records of FILEDSTAFF table onadministrator login?

User login is also not working !

Thanks in advance

Sajith

follwoing Script are used, attached the qvw also.

STAR IS *;

Section Access;load * Inline [
     ACCESS,USERID,PASSWORD,F1,F2,F3,F4,F5
     ADMIN, ADMINISTRATOR,ADMIN@123,*,*,*,*,*,*
     USER,U1,U1,MR1,,,,
     USER,U2,U2,MR2,,,,
     USER,U3,U3,MR3,,,,
     USER,U4,U4,*,AM1,,,
     USER,U5,U5,*,AM2,,,
     USER,U6,U6,*,*,RM1,,
     USER,U7,U7,*,*,*,ZM1,
     USER,U8,U8,*,*,*,*,GM
     ];

Section Application;

FIELDSTAFF:

LOAD * INLINE [
    FSCODE,F1,F2,F3,F4,F5,TYPE
     MR1,MR1,AM1,RM1,ZM1,GM,1
     MR2,MR2,AM1,RM1,ZM1,GM,1
     MR3,MR3,AM2,RM1,ZM1,GM,1
     AM1,,AM1,RM1,ZM1,GM,2
     AM2,,AM2,RM1,ZM1,GM,2
     RM1,,,RM1,ZM1,GM,3
     ZM1,,,,ZM1,GM,4
     GM,,,,,GM,5
];

TYPE_MST:

LOAD * INLINE [
     TYPE,DESIGNATION
     1,Reps
     2,Area Manager
     3,Regional Manager
     4,Zonal Manager
     5,General Manager
     ];

User access data reduction based on login

Thu, 01 Dec 2011 05:08:56 GMT

I resolved this by making the follwoing change in the script

Section Access;

ACCESS,USERID,PASSWORD,F1,F2,F3,F4,F5

ADMIN, ADMINISTRATOR, ADMIN@123,ALL,ALL,ALL,ALL,ALL,ALL

USER,U1,U1,MR1,ALL,ALL,ALL,ALL

USER,U2,U2,MR2,ALL,ALL,ALL,ALL

USER,U3,U3,MR3,ALL,ALL,ALL,ALL

USER,U4,U4,ALL,AM1,ALL,ALL,ALL

USER,U5,U5,ALL,AM2,ALL,ALL,ALL

USER,U6,U6,ALL,ALL,RM1,ALL,ALL

USER,U7,U7,ALL,ALL,ALL,ZM1,

USER,U8,U8,ALL,ALL,ALL,ALL,GM

];

Thanks to Paul Rajesh

topic User access data reduction based on login in QlikView

User access data reduction based on login

User access data reduction based on login