topic section access in QlikView

section access

Thu, 09 Feb 2012 09:09:23 GMT

Hi there,

i have a question related to section access:

I want to hide a certain object (button) and a certain sheet from the users that i have defined in an outsourced section access table as ACCESS = USER.

All the ACCESS = ADMIN in this table shall see both - the sheet and the button.

How do i check on the user (whether its a USER or an ADMIN) on a sheet and button respectively ?

Thanks for some clues.

regards,

section access

Thu, 09 Feb 2012 09:22:16 GMT

Hi,

As per my knowledge Admin can access all the sheets, but the user can see only related sheets as per the password given to the sheets.

If am wrong plz.

Thanks,

Rathish

Re: section access

Miguel_Angel_Baeyens — Thu, 09 Feb 2012 10:11:51 GMT

Hi,

You cannot check whether a given user has or has not ADMIN permissions under the ACCESS field in section access, but you can add a new field (called PERMISSIONS) where you can use those values:

SECTION ACCESS;

LOAD * INLINE [ // Or whatever source of your security table

ACCESS, USERID, PASSWORD, PERMISSIONS

ADMIN, ADMIN, ADMIN

ADMIN, MANAGER, MANAGER, 1

USER, REP, REP, 0

];

SECTION APPLICATION;

If PERMISSIONS is equal to or greater than zero, then the user is an admin so he or she can see the objects, otherwise, the object will be hidden.

Hope that helps.

Miguel

section access

Thu, 09 Feb 2012 10:28:52 GMT

Thanks, Miguel.

I dont want to work with USERID & PASSWORD in section access.

I am working with NTNAME - Will your approach still work ?

How would i check if the user has permission 1 or 0. QVUser() returns nothing when not working with USERID / PASSWORD...

Thanks a lot.

Re: section access

chris_johnson — Thu, 09 Feb 2012 10:49:08 GMT

Hi,

I have previously created another table, outside of section access (but that still links to it) and then created my extra columns there.

In your case I could imagine creating another table with perhaps ACCESS and QVUser columns and then checking the value of QVUser to determine if the button should be shown or not. Because the ACCESS column will link from your section access to the new table it will filter it down so you will only end up with 1 row in your new table so you shouldn't have a problem checking this field value.

Chris

Re: section access

Miguel_Angel_Baeyens — Thu, 09 Feb 2012 11:55:33 GMT

Hi,

Consider the following piece of script.

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, PERMISSIONS
ADMIN, DOMAIN\USER1, 1
USER, DOMAIN\USER2, 0
];
SECTION APPLICATION;
LOAD * INLINE [
PERMISSIONS
1
0
];

Assume there is a text object with the following condition:

Sum(PERMISSIONS)

If the user that is logging in is USER1, the text object will appear. Otherwise, the text object will still be there, but hidden.

Hope that makes more sense.

Miguel

Re: section access

Thu, 09 Feb 2012 12:00:20 GMT

I have to correct myself.

After LOAD of my application there is no selection in any field - this includes PERMISSIONS - and hence i see the text field, even if i would be USER2.

Any idea, how to solve this ?

(Without creating an automatic selection, which the user could erase...)