topic Re: Security Access in QlikView

Security Access

tracycrown — Wed, 25 Nov 2020 16:16:04 GMT

Dear all

I had created following script but several problems encountered :

1. System asked for UserID but it did not ask for password.

2. System should allow Admin to access all Sheets, User C to access Sheet3 only but it allows User C to access all Sheets.

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
Admin, Admin, admin
User, A, a
User, B, b
User, C, c
];

Section Application;
LOAD * INLINE [
USERID, SHEET
Admin, ALL
A, Sheet1
B, Sheet2
C, Sheet3
];

Thank You

Tracy

Re: Security Access

hari8088 — Fri, 03 Jun 2016 10:30:59 GMT

Hi In Section application

Give like this

LOAD * INLINE [
USERID, [Sheet ID]
Admin,
A, SH01
B, SH02
C, SH03
];

Then make shore click "Scrict Exclution" in document properties

Re: Security Access

marcus_sommer — Fri, 03 Jun 2016 10:31:13 GMT

The reason for this behaviour is that there are no data which are connected with the section access - if you add one (like in the attachement) you will be queried for the password. Here you will find many informations about Section Access.

- Marcus

Re: Security Access

rubenmarin — Fri, 03 Jun 2016 10:56:11 GMT

Hi Tracy, in document properties (CTRL+ALT+D)-->'On Open' tab--> Check the 'Initial Data Reduction Based on Section Access'.

This will restrict the SHEET field values each user can see. And also it will start asking for password.

Re: Security Access

MindaugasBacius — Fri, 03 Jun 2016 11:04:40 GMT

The other way to restrict using the sheets are the conditions in Sheet properties.

Re: Security Access

sasiparupudi1 — Mon, 06 Jun 2016 11:22:01 GMT

Please see the attached document.. hope this helps

Sasi