Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access based on Section Application

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.

3 Replies
Not applicable
Author

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
Partner - Creator III
Partner - Creator III

Did you back it up?

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

Not applicable
Author

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