topic Re: Mange users permissions using section access in QlikView

Mange users permissions using section access

Thu, 28 Nov 2013 14:06:57 GMT

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

Re: Mange users permissions using section access

saumyashah90 — Thu, 28 Nov 2013 14:11:27 GMT

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

Re: Mange users permissions using section access

datanibbler — Thu, 28 Nov 2013 14:13:56 GMT

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

Re: Mange users permissions using section access

Gysbert_Wassenaar — Thu, 28 Nov 2013 14:15:37 GMT

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.

Re: Mange users permissions using section access

Thu, 28 Nov 2013 15:03:52 GMT

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

Re: Mange users permissions using section access

Thu, 28 Nov 2013 15:29:11 GMT

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