topic Re: data security in qlik sense in Integration, Extension & APIs

data security in qlik sense

Anonymous — Sun, 13 May 2018 04:43:06 GMT

Hi,

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

table1

No Country

1 India

2 Eng

thanks

Re: data security in qlik sense

petter — Sun, 13 May 2018 10:50:24 GMT

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-section-access.htm

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-reduction.htm

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

];

Re: data security in qlik sense

Anonymous — Sun, 13 May 2018 15:53:34 GMT

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

Re: data security in qlik sense

petter — Sun, 13 May 2018 16:02:40 GMT

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...

Re: data security in qlik sense

Anonymous — Sun, 13 May 2018 16:10:31 GMT

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

Re: data security in qlik sense

Anonymous — Sun, 13 May 2018 16:10:55 GMT

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

Re: data security in qlik sense

Anonymous — Sun, 13 May 2018 16:20:06 GMT

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

Re: data security in qlik sense

petter — Sun, 13 May 2018 16:45:20 GMT

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

Re: data security in qlik sense

Anonymous — Mon, 14 May 2018 02:49:38 GMT

it is row level security what about data level

Re: data security in qlik sense

Anonymous — Wed, 16 May 2018 03:56:24 GMT

Suggestion please

Re: data security in qlik sense

Anonymous — Wed, 16 May 2018 06:03:47 GMT

Suggestions please

Re: data security in qlik sense

petter — Wed, 16 May 2018 09:43:17 GMT

What do you mean by data level? You mean field/column level right?

You can use OMIT to hide specific fields from different roles/groups/users with the SECTION ACCESS ...

Re: data security in qlik sense

Anonymous — Wed, 16 May 2018 14:19:40 GMT

can you please help me with the steps information

Re: data security in qlik sense

Anonymous — Sun, 20 May 2018 12:27:32 GMT

logic is unclear to me...anyone else can contribute

Re: data security in qlik sense

Anonymous — Sun, 20 May 2018 12:48:49 GMT

why two inline load and purpose and what about column level security