topic Re: Section access based on Section Application in QlikView

Section access based on Section Application

Thu, 23 May 2013 12:51:02 GMT

Hello,

How come this does not work?

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, Hans, DuEr1

USER, Kent, DuEr2

USER, Olga, DuEr3

];

Section Application;

LOAD * Inline [

USERID, CustomerID

Hans, UHMD

];

I want the user hans only able to see CustomerID UHMD (its a string)

I have this table in my edit script

QUALIFY*;

UNQUALIFY CustomerKey;

DimCustomer:

LOAD CustomerKey,

PartnerID,

CustomerID,

PartnerKey,

LaCustomerKey;

SQL SELECT *

FROM DW.dbo.DimCustomer;

UNQUALIFY*;

When i try to go into my qvw doucment i get access denied, except on admin level, i am allowed to go to my qvw file.

Thu, 23 May 2013 13:08:34 GMT

okay What do i do if i closed my self out of the document ? i just tried with NTname, and now i cannot access my document.

RedSky001 — Thu, 23 May 2013 14:22:13 GMT

Did you back it up?

It's good to backup any seciton access document before you make changes (I guess you know why...)

Fri, 24 May 2013 08:26:19 GMT

hehe no i forgot but yes, i was very stupid ;D