Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please let me know if we can create a security rule for restricting sheets in an App for some particular users.
Like some sheets must be visible to one particular user and other sheets to second user.
Please let me know.
Thanks in Advance.
Karthik
create appliation with sheet names as
Sheet1 and Sheet2
then use following code as section access
Section Access;
LOAD * INLINE [
ACCESS, USERID
Admin, A
User, B
User, C
USer, D
];
Section Application;
SheetAccessMatrix:
LOAD upper([USERID]) as [USERID],
Sheet1,
Sheet2
FROM
sheetlevel.xlsx
(ooxml, embedded labels, table is Sheet1);
Note:sheetlevel.xlsx (in attachment)
otherwise create excel with following data:
USERID | Sheet1 | Sheet2 |
A | 1 | 1 |
B | 0 | 1 |
C | 1 | 0 |
D | 1 | 1 |
Hi Arvind,
Thank you for the response.
We will check once about the resolution you provided. The attachment was missing in the reply you provided.
Also please let me know if we can restrict user through security rules for sheets.
Thanks,
Karthik
Hi Karthik By default, the user who have access in stream will have access for all sheets. You will need to change the default policies as described above Sheet or App Object Level Security Qlik Sense
My suggested approach to implementing Sheet Level Security is to create four new Security Rules after disabling the default rules. It involves a User Directory with properties for the Company, Application, and Sheets. Custom properties in the QMC will need to be created to contain the same User Directory property values.
Custom properties are created, in the QMC, and assigned to the individual Applications and Streams. This allows for a general approach to handling an expanding list of Companies and their various Applications. As the number of Applications and Companies grow, the User Directory Properties and Custom Properties will both need to be updated to grant access to the new applications and the application's sheets.
Security Rule to Disable is the Stream rule...
Rule Name = Stream
Resource Filter = App*
Rule for Sheets
((
user.userDirectory="Specific User Group"
and resource.objectType="sheet"
and user.sheets=resource.name
))