Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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];
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
Try this
User admin and pass admin1 .
Hope this helps you.
Vikas
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
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
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