Section Access

[#1]

Hi,

I need help in doing the section Access.

I have two xls files.One as userdetails and other as the Security details.

Attached the file for your reference. i am able access only the users with Access as ADMIN and the other user id's i am not able to access. it is throwing the error wrong username and Password. Is there anyting related to License or why i am getting this error??

Please help me it is very urgent.

Reagrds,XXXX

[kji]

ACCESS has to be either ADMIN or USER, no other values have any meaning

[#3]

can You please brief your answer i didnt get your answer...Please

[syed_muzammil]

Hi,

In the Access column you cannot have values other than ADMIN and USER.

[#5]

Thanks Syed,

So how does i will be able to restrict based on the Designation. Should i need to add one more as Designation and need to restrict the access..Please suggest.

Thanks..

XXX

[syed_muzammil]

Hi,

Irrespective of the designation you can grant complete access only to ADMIN and restrict other USERS. You can can have one more column designation. Using this you can give different levels of access to different users in the Section Applications. For detailed information on section Access application you can see the Help doc. in QLikView or search for Section Access post in this forum.

[#7]

Thanks Syed.

I am trying the same by adding the designation but while debugging i am getting the error as Server Compatibilty waring and and Type D detected. i have posted the error in the forum just now. Any idea when it will come.

Reagrds,

XXX

[#8]

Hi Syed,

Now it is different issue i am facing in the section Access. What ever the user i am trying to login i am able to see all the sheets.

I have added one more column as Permissions and defined the dessignations and still it is prompting for username and password.

and works only for the username and password what i have defined in the Xls file.But all users have access to all sections.

I am not sure where i am missing

Please find the user details and the script

User.xls

USERID	PASSWORD	ACCESS	PERMISSION
name1	test123	ADMIN	MANAGER
name2	test123	ADMIN	MANAGER
name3	test123	ADMIN	MANAGER
name4	test123	USER	PE
name5	test123	USER	PE
name6	test123	USER	ME
name7	test123	USER	SE
name8	test123	USER	ME
name9	test123	USER	SE

Security .Xls

PERMISSION	SH01	SH02	SH03	SH04	SH05	SH06	SH07
PE	1	0	0	0	1	1	1
MANAGER	1	1	1	1	1	1	1
ME	1	0	1	0	1	0	1
SE	0	1	0	0	0	0	1

And the code i am using is

Section access;

Directory;

LOAD [USERID],

[PASSWORD],

[ACCESS],

PERMISSION

FROM

(biff, embedded labels, table is Userdetails$);

Section application;

Directory;

LOAD PERMISSION,

SH01,

SH02,

SH03,

SH04,

SH05,

SH06,

SH07

FROM

(biff, embedded labels, table is Sheet1$);

Regards,XXX