section access object id based security

[New-Qlik]

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;

[Anil_Babu_Samineni]

Refer this

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

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

How to restrict sheet objects using section access | Qlik Community

[#3 · Accepted solution]

Hi

You can check this Doc Chart Level Access by user

[New-Qlik]

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:(

[#5]

Hi

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