Security

[am421]

How to Apply Row level security in Qlik?

[Prashant_N]

Hi,

please check if this link helps - https://community.qlik.com/t5/New-to-Qlik-Analytics/row-level-security-how-to/td-p/845445

[TauseefKhan]

Hi @am421,

To apply row-level security in Qlik, you can use the Section Access feature. It's a powerful and flexible way to control data visibility at the row level within your apps.

Example:

SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, REDUCTION_FIELD
USER, USER_A, DATA_A
USER, USER_B, DATA_B
ADMIN, ADMIN, *
];

SECTION APPLICATION;
// Your data load script continues here

In this script:
• ACCESS specifies the level of access (USER or ADMIN).

• USERID is the identifier for the user.

• REDUCTION_FIELD is the field used for data reduction, allowing users to see only their authorized data.

• An asterisk * in the ADMIN row under REDUCTION_FIELD means the admin has access to all data.

For more details you can refer:
https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage...