Problem in Section Access

[amars]

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 [:'(]

[#2]

Hi,

Can you post your script here..?

- Sridhar

[#3]

Hi Amar,

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

Login Details:

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

[amars]

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.