Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Omit in Section Access

Hi i am playing with Omit Groups in section Access. I am trying to restrict access to particular field using omit groups depending on roles admin and users .

Here is my sample .

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMITGROUP

ADMIN, admin, admin,

USER, user1, user1,

USER, user2, user2, SALARYONLY

USER, user3, user3, SALARYANDABSENCE

USER, user4, user4, ABSENCEONLY

];

OmitGroups:

LOAD * INLINE [

OMITGROUP, OMIT

SALARYONLY, Salary

SALARYANDABSENCE, Salary

SALARYANDABSENCE, Absence

ABSENCEONLY, Absence

];

Section Application;

//Employees:

LOAD * INLINE [

EmpID, Name, Salary, Absence

1, Joe Bloggs, 50000, 3

2, Jane Doe, 45000, 5

3, Fred Frank, 30000, 0

4, Jeri Jublek, 19000, 12

];

I have restricted the access to Salary field for 'user2 '.But if i login with user2 credentials i can see all the data what admin can view .

Please clarify me

Thanks

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Did you tick "Initial Data Reduction..."?

Capturar.PNG

View solution in original post

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try with:

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, admin, admin,

USER, user1, user1,

USER, user2, user2, Salary

USER, user3, user3, Salary

USER, user3, user3, Absence

USER, user4, user4, Absence

];

Let me know

Anonymous
Not applicable
Author

Hi, try this:

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, admin, admin,

USER, user1, user1,

USER, user2, user2, Salary

USER, user3, user3, Salary

USER, user3, user3, Absence,

USER, user4, user4, Absence

];

KR

Gysbert_Wassenaar

I think the OMIT field has to be part of the Section Access table itself.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

It's not working .The same result what i got

Thanks

alexandros17
Partner - Champion III
Partner - Champion III

Send all the script related to section access ...

Clever_Anjos
Employee
Employee

Did you tick "Initial Data Reduction..."?

Capturar.PNG

Anonymous
Not applicable
Author

Thank you !! Working fine