topic Re: section access object id based security in QlikView

section access object id based security

New-Qlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I want to implement section access based on objects under dashboard

example

admin can see alll

user can see all charts except 'CH04, CH06, CH07 '

my script is like this

User:
SQL SELECT
    FirstName,
    LastName,
    LoginID,
     Password,
    RoleMasterID,
    UserDetailsID
FROM UserDetails;

SECTION ACCESS;
Load Upper(LoginID) as USERID,
UPPER(Password) as PASSWORD,
'USER' AS ACCESS

Resident User;
SECTION APPLICATION;
Drop table User;

Re: section access object id based security

Anil_Babu_Samineni — Sun, 31 Jul 2016 14:12:02 GMT

Refer this

https://community.qlik.com/search.jspa?q=section%20access,%20objects&_ga=1.39092899.180209794.1463408175

Section access sheet level and object level ex... | Qlik Community

How to restrict sheet objects using section access | Qlik Community

Re: section access object id based security

Sun, 31 Jul 2016 14:14:11 GMT

You can check this Doc Chart Level Access by user

Re: section access object id based security

New-Qlik — Sun, 31 Jul 2016 18:27:44 GMT

It is really helpful.

But I have one doubt.

I am picking up users from database, there role are define into column name as roleMasterid .

so RoleMaster id has four role like 1,2.3,4

1. has all access so its admin

2. has only vierw to all charts

3. and 4 have view access to all charts except few charts.

below is not working. Please suggest where m wrong

User:
SQL SELECT
FirstName,
    LastName,
    LoginID,
      Password,
    RoleMasterID,
FROM UserDetails;

SECTION ACCESS;
Load Upper(LoginID) as USERID,
UPPER(Password) as PASSWORD,
'USER', 'Admin' AS ACCESS,
RoleMasterID

Resident User;

LOAD * INLINE [
    ACCESS, RoleMasterID
    Admin, 1
    User, 2
    User, 3
    USer, 4
];
Section Application;

ChartAccessMatrix:
LOAD * INLINE [
RoleMasterID, CH01,BM01,CH02,CH03,BM05,CH10,CH11,CH12
1,1,1,1,1,1,1,1,1,
2,1,1,1,1,1,1,1,1
3,0,0,0,0,0,1,1,1
4,0,0,0,0,0,1,1,1];

after adding this I am not able to login to qvw with nay of the usernames:(

Re: section access object id based security

Mon, 01 Aug 2016 04:37:08 GMT

Did you applied the condition in Chart Properties -> Layout -> Show -> Conditional for your required charts like CH01 etc after that you can apply that script and try it.

Note : Go through the comments in Chart Level Access by user there it was explained clearly