topic Column level security with custom text in App Development

Column level security with custom text

sjar1290 — Tue, 30 Aug 2022 14:46:59 GMT

HI All,

my requirement is,

If you Login as ADMIN, you will have all the access to all the data

Id	Name	Product	SSN	Phone	Region
1	abc	xyz	100	20	US East
2	dfr	123	200	30	US West

If you login as USER,

the table structure should be same and I should not be able to see the SSN and Phone Info and instead of blank space I need to show "No access" message

Id	Name	Product	SSN	Phone	Region
1	abc	xyz	No Access	No Access	US East
2	dfr	123	No Access	No Access	US West

I can get the desired result by using a condition at the UI level, but I don't want to go in that path, because we need to educate all the app developers to write the function at the UI side for many number of columns to restrict the access, that's going to be a hell of a challenge.

So, is there any way we write some function at the script level to display the custom text, instead of using function in UI side to display custom text?

any help would be appreciated.

Thank you,

Raj.

Re: Column level security with custom text

marcus_sommer — Wed, 31 Aug 2022 11:38:00 GMT

I'm not sure but I believe it won't be possible - at least not in your described way and/or without extra logic and/or extra efforts. The reason is the field-value for a certain record could have only a single value. If you want to show a user-depending value you need to query the user and to replace this value or to replace this field against another or maybe hiding the values.

An alternatively could be to implement a Section Access - Qlik Community - 1493681 which provides with OMIT a feature to remove these fields. Means these fields will be completely erased from the data-model so that you couldn't display 'no access'. Normally that's not a disadvantage else an intended behaviour to not to hint an user for the exists of restricted data.

- Marcus

Re: Column level security with custom text

SunilChauhan — Wed, 31 Aug 2022 13:43:16 GMT

uSe OMIT In Section access to OMIT access of

i have tried Below Script. Showing For Sunil and Hiding for Vandana

Section Access;
Load * inline[
ACCESS,USERID,OMIT
Admin,Sunil
User,Vandana,SSN
];
Star is *;
Section Application;
Load * Inline [
Id, Name, Product, SSN ,Phone, Region
1, abc ,xyz, 100 ,20 ,US, East
2, dfr ,123, 200 ,30, US ,West
];