security in Qlikview

[#1]

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

[Siva_Sankar]

Hi Sing,

Refer the document with examples here QlikView Section Access Examples

[tresesco]

Have a look here: Introduction to Section Access

[its_anandrjs]

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

[#5]

Hi All,

Thanks for your reply..

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

[#6]

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;

[avinashelite]

HI Sanjay,

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

and in

Section application;

Data;

[#8]

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

[#9]

it gives as 'Access denied to this qlickview document'

[sasikanth]

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