topic Section Access in QlikView

Section Access

Mon, 19 Jul 2010 12:13:42 GMT

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

Section Access

kji — Mon, 19 Jul 2010 12:26:20 GMT

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

Section Access

Mon, 19 Jul 2010 13:51:43 GMT

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

Section Access

syed_muzammil — Mon, 19 Jul 2010 14:10:10 GMT

Hi,

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

Section Access

Mon, 19 Jul 2010 14:14:09 GMT

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

Section Access

syed_muzammil — Mon, 19 Jul 2010 14:29:22 GMT

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.

Section Access

Mon, 19 Jul 2010 14:35:22 GMT

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

Section Access

Mon, 19 Jul 2010 15:38:43 GMT

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