Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

rupesh632
Contributor

data security in qlik sense

Hi,

can you help me with data security/hide on country wise

table1

No Country

1   India

2   Eng

thanks

14 Replies
MVP
MVP

Re: data security in qlik sense

You should use "section access" to get the kind of security you need:

The general help for section access:

https://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/Scripting/Security/manage-security-with...

The more specific example - which is called dynamic data reduction:

https://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/Scripting/Security/dynamic-data-reducti...

So applied to your example it might look like this:

SECTION ACCESS;     // Starts the special section of the load script where access is defined

LOAD * INLINE [

ACCESS, USERID,COUNTRY    

USER, AD_DOMAIN\ADMIN,*

USER, AD_DOMAIN\A, India

USER, AD_DOMAIN\B, Eng

USER, AD_DOMAIN\C, India

USER, INTERNAL\SA_SCHEDULER,*

];


SECTION APPLICATION; // Starts the section which is the regular or normal load script part

table1:

LOAD *,

  Country AS COUNTRY;

LOAD * INLINE [

No, Country

1, India

2, Eng

];


More links:

rupesh632
Contributor

Re: data security in qlik sense

let's assume that Country table having 10 lacs records  then why we have to load inline

for an example: select * from country where country -'Eng' this kinds data security is  expected

why this inline condition ?

SECTION APPLICATION; // Starts the section which is the regular or normal load script part

table1:

LOAD *,

  Country AS COUNTRY;

LOAD * INLINE [

No, Country

1, India

2, Eng

];


and will this conditon sufficient to restrict the data for the particular user

SECTION ACCESS;     // Starts the special section of the load script where access is defined

LOAD * INLINE [

ACCESS, USERID,COUNTRY   

USER, AD_DOMAIN\ADMIN,*

USER, AD_DOMAIN\A, India

USER, AD_DOMAIN\B, Eng

USER, AD_DOMAIN\C, India

USER, INTERNAL\SA_SCHEDULER,*

];


finally can we use group instead of User

MVP
MVP

Re: data security in qlik sense

It is purely an example so you can see the data involved. You replace the INLINE part of the load with either a FROM or most likely a following SQL statement...

rupesh632
Contributor

Re: data security in qlik sense

I wanted under how this security will work via first inline statement and 2nd normal normal load table or how

rupesh632
Contributor

Re: data security in qlik sense

I wanted under how this security will work via first inline statement and 2nd normal load table or how

rupesh632
Contributor

Re: data security in qlik sense

I wanted understand how this security will work via first inline statement and 2nd normal load table or how

MVP
MVP

Re: data security in qlik sense

Look at the second link in my first answer and read the documentation to understand if you find my example insufficient.

rupesh632
Contributor

Re: data security in qlik sense

it is row level security what about data level

rupesh632
Contributor

Re: data security in qlik sense

Suggestion please

Community Browser