Row level Section access- based on dashboard user name

[Noob3]

Hi All,

Need Help.

I want to apply row-level access based on the user who is accessing the dashboard.

The user should see and search only the rows where the username (who is accessing the dashboard) matches the value in the column "assigneduser".

All users are in Active directory.

i applied the section access as below , but it's not working.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTIONFIELD
ADMIN, dir\<MySelf>,     *
ADMIN,dir\Analytics.Engineering, *
ADMIN, dir\Analytics.Prod.Support, *

ADMIN, INTERNAL\SA_SCHEDULER, *
USER, dir\rahul.t,              rahul.t 
USER, dir\rohit.k,               rohit.k
USER, dir\chetan.d,          chetan.d
USER, dir\sai.p,                sai.p
];

Section Application;

Adminasset:
LOAD
AutoNumber(assetid) as AssetID,
assetid as AdminassetId,
computername,
assigneduser AS REDUCTIONFIELD, 
assettype & '-' & pcmodel & '-' & serialnumber as Asset,
assettag

FROM $(vQVDPath)\assetinfo.qvd(qvd)

[MatheusC]

@Noob3 

Function Upper()

Note: When adding a question, please look for the appropriate forum for your query. This will make it easier and faster to find your solution.


https://community.qlik.com/t5/Official-Support-Articles/How-To-Validate-And-Troubleshoot-Section-Acc...

- Matheus

[Noob3]

Hi MatheusC,

Thank you for your response.

I tried the uppercase function, and the script runs fine without any errors. 
but it seems all users are still able to see all rows,

Section Access;
LOAD * INLINE [
ACCESS, NTNAME,                REDUCTIONFIELD
ADMIN, DIR\<MySelf>,                                 *
 ADMIN, DIR\2758_Qlik_STG,                    *

ADMIN, INTERNAL\SA_SCHEDULER,       *
USER, DIR\RAHUL.T,                             RAHUL.T 
USER, DIR\ROHIT.K,                             ROHIT.K
USER, DIR\CHETAN.D,                       CHETAN.D
USER, DIR\SAI.P,                                SAI.P
];

Section Application;

Adminasset:
LOAD
AutoNumber(assetid) as AssetID,
assetid as AdminassetId,
computername,
 upper(assigneduser) AS REDUCTIONFIELD,
assettype & '-' & pcmodel & '-' & serialnumber as Asset,
assettag

FROM $(vQVDPath)\assetinfo.qvd(qvd)

[MatheusC]

@Noob3 

Try putting user restrictions first and then those with asterisks *


- Matheus

[Noob3]

Tried, but no change.

Also, i just realized that it's not even showing list of users in the column NTNAME.

[MatheusC]

For testing I would also advise using an inline table and see the result.

Adminasset:
Load * Inline [

REDUCTIONFIELD
SAI.P
CHETAN.D

];

Then if you haven't visited it yet, check the post above, or review the steps highlighted in the post, to validate the information in your table with the Section Access reduction, so you can apply the restriction.

https://community.qlik.com/t5/Official-Support-Articles/How-To-Validate-And-Troubleshoot-Section-Acc...

Regards!