topic Re: security in Qlikview in QlikView

security in Qlikview

Thu, 24 Jul 2014 05:54:44 GMT

Hi,

Would like to know how to implement security in Qlikview using the section acess.

Please share the Qvw example for the needfull..

Regards,

Singh Sanjay

Re: security in Qlikview

Siva_Sankar — Thu, 24 Jul 2014 05:58:31 GMT

Hi Sing,

Refer the document with examples here QlikView Section Access Examples

Re: security in Qlikview

tresB — Thu, 24 Jul 2014 05:59:34 GMT

Have a look here: Introduction to Section Access

Re: security in Qlikview

its_anandrjs — Thu, 24 Jul 2014 05:59:53 GMT

Read about the section access and implement according to documents

How to Distribute Dashboard and Implement Section Access

QlikView Section Access Examples

Introduction to Section Access

Re: security in Qlikview

Thu, 24 Jul 2014 06:37:11 GMT

Hi All,

Thanks for your reply..

I implemented the logic , but when i logg in as USER it doesnt filter the data.

Re: security in Qlikview

Thu, 24 Jul 2014 06:38:32 GMT

Main Section:-

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorksDW2008R2;Data Source=SANJAYS-MSD;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SANJAYS-MSD;Use Encryption for Data=False;Tag with column collation when possible=False];

LOAD * Inline [

Col1,DATA

User,sanjay

User,ABC

]

Hidden Script:-

Section Access;

trace <<< Section Access >>> ;

// This now works because the field names below are in UPPERCASE

// Users are restricted to only see the Costcentres they have access to

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD,DATA

Admin, Admin, Admin,*

User,User,User,sanjay

User,User2,User2,ABC

];

trace <<< Section Application >>> ;

section Application;

Re: security in Qlikview

avinashelite — Thu, 24 Jul 2014 06:39:18 GMT

HI Sanjay,

Have you selected the strict data reduction in the document properties> opening > please select strict data reduction.

and in

Section application;

Data;

Re: security in Qlikview

Thu, 24 Jul 2014 06:43:55 GMT

if i select that option.. i doesnt allow me to login as 'user'

Re: security in Qlikview

Thu, 24 Jul 2014 06:44:54 GMT

it gives as 'Access denied to this qlickview document'

Re: security in Qlikview

sasikanth — Thu, 24 Jul 2014 06:49:36 GMT

Section Access

ACCESS, USERID, PASSWORD,DATA

ADMIN,AX,AX,ALL

USER,user1,user1,AUS

USER,user2,user2,US

Section Application

check , initial data reduction based on section access,

if you check the strict exclusion, then if the specified data is not there it should not allow your user

uncheck -->Strict Exclusion check again

Re: security in Qlikview

Thu, 24 Jul 2014 07:00:31 GMT

Check this Qvw.. Everything is set but still unable to login..

Re: security in Qlikview

Thu, 24 Jul 2014 07:00:47 GMT

Check this Qvw.. Everything is set but still unable to login..

Re: security in Qlikview

Thu, 24 Jul 2014 07:00:56 GMT

Check this Qvw.. Everything is set but still unable to login..

Re: security in Qlikview

Thu, 24 Jul 2014 07:03:02 GMT

unable to attach the qvw on this link..