Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mange users permissions using section access

Hi,

How can I Manage Users permissions using Section Access for files.

For example:

User1 can open and use File1, but User2 can't,

User2 and User3 can open and use File2, but User1 can't.

User 4 can access all files.

Thanks in advance,

Itsik

1 Solution

Accepted Solutions
datanibbler
Champion
Champion

Hi Itsik,

Section_access is quite well explained in the help_file.

Generally, you have

- two kinds of access (that you can specify there):

  - ADMIN

  - USER

- You can define what the people with USER access can and cannot do. ADMIN as a rule can do everything.

You have several methods how people can identify themselves. The most common:

- Logon ticket (username/ password)

- NTNAME (the logon they use for their PCs)

! Be careful and, before experimenting with this, create backup_copies - you could easily lock yourself out of your own apps and no one could help you in that case !

=> I was facing the same issue and I decided using logon_tickets was too cumbersome (users then always have to identify themselves, there's no way around it).

=> You could store the NTNAME_values in an Excel_list in some secured place.

HTH

Best regards,

DataNibbler

View solution in original post

5 Replies
saumyashah90
Specialist
Specialist

Can you specify Files here?
Is it a QlikViewApplication,Sheet,Data?

datanibbler
Champion
Champion

Hi Itsik,

Section_access is quite well explained in the help_file.

Generally, you have

- two kinds of access (that you can specify there):

  - ADMIN

  - USER

- You can define what the people with USER access can and cannot do. ADMIN as a rule can do everything.

You have several methods how people can identify themselves. The most common:

- Logon ticket (username/ password)

- NTNAME (the logon they use for their PCs)

! Be careful and, before experimenting with this, create backup_copies - you could easily lock yourself out of your own apps and no one could help you in that case !

=> I was facing the same issue and I decided using logon_tickets was too cumbersome (users then always have to identify themselves, there's no way around it).

=> You could store the NTNAME_values in an Excel_list in some secured place.

HTH

Best regards,

DataNibbler

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

It's far simpler to use NTFS permissions to restrict access to files. Just remove the file read permission on File1 for User2 to make sure User2 cannot open the file and remove the file read permission on File2 for User1.

If you want to do this with section access you need to add a section access block to each file and for example don't add User2 to the section access table for File1. That way User2 won't be able to open File1. Similar for the other files.


talk is cheap, supply exceeds demand
Not applicable
Author

And if I want to manage the access to the tabs(sheets) inside spesific file?, LIke: User1 can see sheet1 but not sheet2

Not applicable
Author

Thanks guys,


Now if I want to manage the access to the tabs(sheets) inside spesific file, LIke: User1 can see sheet1 but not sheet2