topic Problem in Section Access in QlikView

Problem in Section Access

amars — Wed, 03 Jun 2009 15:43:39 GMT

Hi all,

I am having an qlikview file, in which I want to have section access for each user to restrict the user to see his data only. For section access I only use the database so it is not hard coded. But I want an admin user which can see all the data. For creating admin user I use INLINE table & join it with the table used for section access. I have tried it by various ways but when I create a admin user it fails to log in. What should I do?

Thanks in Advance.

Regards

Amar [:'(]

Problem in Section Access

Wed, 03 Jun 2009 15:48:09 GMT

Hi,

Can you post your script here..?

- Sridhar

Problem in Section Access

Wed, 03 Jun 2009 15:55:21 GMT

Hi Amar,

See the attached file. I have created two user (Admin and User)

1) Admin: User id :SAN, Password: SAN.

2) User: User id :XUAA, Password: XUAA.

The admin has access to both the sheets and the user has access to Sheet2 only. Is this you want?.

--Santhosh

Problem in Section Access

amars — Wed, 03 Jun 2009 18:18:54 GMT

My script is like

For_Authentication:

Load UID Resident UserRefTable;

Join LOAD * INLINE
[UID
xyz];

Section Access;

Load UID as USERID, '*' as PASSWORD, UID as GROUP Resident For_Authentication;

Section Application;

Load UID as GROUP Resident For_Authentication;

In first section I have loaded the user ID from database table then I have added the admin user "XYZ" & then used Section access.