topic Section Access Security in QlikView

Section Access Security

Thu, 14 Apr 2011 21:37:30 GMT

I have QV section access working, but now have a new request that I am not sure how to handle. I currently have:

Section Access;

LOAD * INLINE [

USERID, PASSWORD, ACCESS, OMIT, DSM

MYUSER, PSWD, USER, COST, DSMFILTER];

Section Application;

LOAD * INLINE [

USERID, DSM, DSMNumber

MYUSER, DSMFILTER, U08 ];

everything is working. MYUSER logs in and can see U08 ( a sales region) data with no COST data.

But now I need to create a user who can see DSM U08 but only for Customer Number "123".

I am struggling on how to do this. What am I missing?

Thanks,
Stephen

Fri, 15 Apr 2011 16:17:56 GMT

Any suggestions?

Oleg_Troyansky — Fri, 15 Apr 2011 18:31:22 GMT

Add another field CUSTOMER and link CUSTOMER with your existing CustomerID. The key is to link the two security fields (DSM and CUSTOMER) separately

Mon, 18 Apr 2011 18:00:46 GMT

Thanks, got it working.

Stephen