Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to implement section access in hub .. so I do this
first I did this
Section Access;
Access_Table:
LOAD * INLINE [
ACCESS, NTNAME, AuthKey
ADMIN, administrator, *
ADMIN, testuser_1, *
ADMIN, IL\SA_SCHEDULER, *
];
Concatenate(Access_Table)
LOAD
ACCESS,
NTNAME,
AuthKey
FROM [lib://downloads (win1_administrator)/User_Access.xlsx]
(ooxml, embedded labels, table is Sheet1);
Section Application;
User_Access table
ACCESS NTNAME AuthKey
USER W-AMKU1\jn 101
USER W-AMKU1\testuser_1 102
USER W-AMKU1\testuser_2 103
and in sales tab
Sales_Master:
LOAD
ProductID,
Country,
Geography,
Sales,
Pick(Match(Country,'India','UK','USA','Canada','Japan','Austria'),101,102,103) as AuthKey
FROM [lib://downloads (w_administrator)/SALES.xlsx]
(ooxml, embedded labels, table is SALES);
sales table
Product Country Geography Sales
101 India APAC 10002
102 Japan APAC 2000
103 UK AMEC 3300
104 Austria AMEC 4000
105 USA AMER 7000
106 Canada AMER 3000
and in emp tab
EMP:
LOAD
EMPID,
ProductID
FROM [lib://downloads (w_administrator)/EMP.xlsx]
(ooxml, embedded labels, table is EMP);
Emp table
EMPID ProductID
E120 101
E130 102
E140 102
E150 103
E160 104
but when I login through testuser_1 this shows an error
how I resolve this ?
no.. but testuser_1 has access to stream @gmenoutis
Users indeed must have access to a stream/app/sheet/object to see it, but they *also* need a license.
is my authkey is correct ?
Pick(Match(Country,'India','UK','Japan'),101,103,102) as AUTHKEY
Seems fine. But you test it by disabling section access (comment "section access;"). Then proceed to select the USERID you want as a value, and you will see if the associated data show.
@gmenoutis yes thanku .. i allocate license and it works fine 🙂 thanks