Hide Qlikview documents based on logged in user

[#1]

Hi,

Let me explain by an example.

Suppose I have two Qlikview documents QV1, QV2 and two users U1, U2.

By default, each user can see both the documents in web view, instead I would like to add a logic of making the visibility based on the logged in user.

I want to store the values QV1-> U1, QV2 -> U2 in the database.

I need to retrieve these and then control the visibility based on these.

Any ideas?

Thanks,

Jyotsna

[#2]

You can control access from the QMC - assign access to QV1 to U1 etc - that way U2 would not see QV1 and only see the QV2 application.

Or, you control access from within the QVW - on each tab properties conditional show option - set to

lower(OSUser())='u1'

So if you have an application with 2 tabs -  an intro start page and the main report tab - U2 would only see the Start tab.

[#3]

Hi jyotsna,

you can achieve these through section access in application level

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, GROUP

    ADMIN, ADMIN, 123, GROUP1

    USER, 100, 100, GROUP2

    USER2, 101, 101, GROUP3

];

Section Application;

Permisions:

LOAD * INLINE [

GROUP, SH01, SH02, SH03

GROUP1,1,1,1

GROUP2,1,0,1

GROUP3,0,1,1];

[#4]

Hi,

I have used Section Access but when the user clicks on the document in Access point, it prompts for username and password instead of showing "Access denied" message, the user need to enter his username and password and then it comes up with the message. I want to avoid this step of user entering his credentials.

Thanks,

Jyotsna

[vikasmahajan]

Try this

User admin  and pass admin1 .

Hope this helps you.

Vikas

[Bill_Britt]

Hi,

I think the reason you are seeing this is because you have both NTname and UserID in the Section Access load. So, if the users NTname isn't there it prompts them for username and password. Remove the UserID and it will deny access.

Bill

[#7]

Hi Bill,

I just have the NTName in my section access and not the userid, also ntname always has a value but it still prompts for uname/pswd.
Below is my section access script

SECTION Access;

SECURITY:

LOAD

  [User Type] as ACCESS,

  [Domain\Username] as NTNAME,

  '*' as SERIAL

RESIDENT SEC_TEMP;

CONCATENATE(SECURITY)

LOAD * INLINE [

    ACCESS, NTNAME, SERIAL

    ADMIN, *, 2579 6609 1228 5564

    ADMIN, *, 4607 5609 5182 1968

];

Thanks,

Jyotsna

[#8]

Hi Vikas,

As per my requirement, I need to pass the NTName as domain/username and not username and password.

Below is the section access script that i have used

SECTION Access;

SECURITY:

LOAD

  [User Type] as ACCESS,

  [Domain\Username] as NTNAME,

  '*' as SERIAL

RESIDENT SEC_TEMP;

CONCATENATE(SECURITY)

LOAD * INLINE [

    ACCESS, NTNAME, SERIAL

    ADMIN, *, 2579 6609 1228 5564

    ADMIN, *, 4607 5609 5182 1968

];

Thanks,

Jyotsna