topic Conditional Show Using Security in QlikView

Conditional Show Using Security

Wed, 24 Nov 2010 18:56:17 GMT

I am trying to show a sheet only to administrators. I have the following security in the hidden script.

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHOWSHEET, IBEX_DISPOSITION_ATN_LOGIN_ID
ADMIN, ADMIN, ADMIN, 1
ADMIN, DH2343, TEST, 1, DH2343
USER, MY4771, TEST, 0, MY4771
];

Section Application;

In the sheet properties I am using the condition =SHOWSHEET=1 However, even after reloading, SHOWSHEET is in RED and is not an available field to use to show this sheet to administrators only. Any help would be sincerely appreciated.

Thanks
Scott..

Conditional Show Using Security

Miguel_Angel_Baeyens — Wed, 24 Nov 2010 20:10:10 GMT

Hello Scott,

In the section application, create an additional table for that purpose and move the SHOWSHEET field to this new table

SECTION APPLICATION; SheetSecurity:LOAD * INLINE [USERID, SHOWSHEETADMIN, 1DH2342, 1];

Hope that helps

Conditional Show Using Security

Wed, 24 Nov 2010 20:12:45 GMT

Hi,

you can use the sheet properties --> show sheet conditional -->

QVUser()='MANAGER' OR QVUser()='ADMIN' <pre>
and only manager or admin can see this sheet.
Regards, Roland</body>

Conditional Show Using Security

Wed, 24 Nov 2010 20:25:11 GMT

Miguel,

The script you suggested does indeed turn the SHOWSHEET green so that it is usable.

However, when I set the condition SHOWSHEET=1 on the sheet for ADMIN only it denies access to the entire docuement for the non-admin user.

Any suggestions?

Conditional Show Using Security

Miguel_Angel_Baeyens — Wed, 24 Nov 2010 20:37:48 GMT

Scott,

Log into the document as the non admin user and check whether the SecuritySheet table exists. It should, as it have the non-admin user.

Hope this helps

Conditional Show Using Security

Wed, 24 Nov 2010 20:49:37 GMT

Miguel,

I can't login as the non-admin user. The application is denying access to the whole document for any other login accept an admin. Do I need to add "users" to the security table with SHOWTABLE equal to 0?

Thanks
Scott

Conditional Show Using Security

Wed, 24 Nov 2010 21:06:53 GMT

I validated my own question. As soon as I added the non-admin user to the security table and desiganted them as SHOWTABLE 0... everything worked.

Thanks for your help!!

Scott

Conditional Show Using Security

Miguel_Angel_Baeyens — Wed, 24 Nov 2010 21:09:05 GMT

Scott,

Add some other users and move the IBEX_DISPOSITION_ATN_LOGIN_ID field to this other table as well. It seems you are reducing your data using strict exclusion, and the SHOWSHEET field may be affecting the rest of the fields (meaning, is it linked to your datamodel or just to the sheets?)

Hope this helps

Conditional Show Using Security

miredoju — Sat, 21 May 2011 11:54:23 GMT

Hi, my section access works, but I have a lot of users with access to different tabs: Section Access; Load * inline [ NTNAME, ACCESS, USERID, PASSWORD, SSU HANS, USER,,,H-NORD HANS, USER,,,H-WEST HANS, USER,,,H-OST HANS, USER,,,H-SUED ... Is it possible to reduce the script ? My test with * don´t work....: Section Access; Load * inline [ NTNAME, ACCESS, USERID, PASSWORD, SSU HANS, USER,,,H-* Thanks Michael