Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Admin vs User

Hi

Does anyone can detail all the differences between the two access types - Admin and User (defined in section access)?

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In the AccessPoint there is no difference. ADMIN users are treated just the same as regular USERs.

In QV Desktop it depends on what permissions you assign and what kind of security you implement. The big difference between an ADMIN user and a USER user is that you cannot shut out an ADMIN from a document if his/her credentials appear in the section access table. A USER has to live by the restrictions that were set by the developer. An ADMIN can get in and undo/change everything. Except for an optional hidden script.

Best,

Peter

View solution in original post

14 Replies
beck_bakytbek
Master
Master

Hi Dagan,

it is very easy, as admin: you have an Access to all tabrows and you can determine what the user can see (restricted access) and ac user: you can see only by admin restricted tabrows / objects.

If you want to have any examples to this issues, so let me please know, i hope that helps

beck

Anonymous
Not applicable
Author

Thanks. I would be glad to get some examples. thanks

jonas_rezende
Specialist
Specialist

Hi, Tomer Dagan.

See like is defined in Qlikview Reference Manual.pdf.

"29.5 Access Levels in Section Access

Access to QlikView documents can be authorized for specified users or groups of users. In the security table, users can be assigned to the access levels ADMIN or USER. If no access level is assigned, the user cannot open the QlikView document. A person with ADMIN access can change everything in the document. Using the Security page in the Document Properties and Sheet Properties dialogs, a person with ADMIN access can limit the users’ possibilities of modifying the document. A person with USER privileges cannot access the Security pages. Note! ADMIN rights are only relevant for local documents! Documents opened on a Server are always accessed with USER rights. "



Follows a link as an example. https://community.qlik.com/servlet/JiveServlet/previewBody/1853-102-2-3345/Introduction_to_Section_A...


Hope this helps!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

In the AccessPoint there is no difference. ADMIN users are treated just the same as regular USERs.

In QV Desktop it depends on what permissions you assign and what kind of security you implement. The big difference between an ADMIN user and a USER user is that you cannot shut out an ADMIN from a document if his/her credentials appear in the section access table. A USER has to live by the restrictions that were set by the developer. An ADMIN can get in and undo/change everything. Except for an optional hidden script.

Best,

Peter

beck_bakytbek
Master
Master

Hi Dagan, this my way of proceeding, if you copy those steps on the base of your own example, you have then automaticaly the solution to your issue:

step 1:

load following scrip:

// Section Access

Access:

Load * INLINE [

Access, USERID, PASSWORD, Link

ADMIN, admin, admin, *

USER, user1, user1, US

USER, user2, user2, UK

];

Sales

Load * Inline [

Link, Country, Sales

US, USA, 150

UK, United Kingdom, 250

];

then you shoud save as Securty1.qvw and reload

and conform that each user is associated with the values that are expected ( you see: as admin you will not be associated with any countries- this is ok)

Save your document as Security2.qvw.and edit the script and uncomment the Section Access Statement. and again you should reload your document and the USERID fiélds will become unavailable.

now, very importing steps:

Settings menu > Select Document Properties and click on the Opening tab and turn on the Initial Data Reduction Based on Section Access Option. Make sure that Sctrict Exclusion is selected

Save and Close your Document:

from the Settings menu, select User Preferences, make sure that the Remember Login Credentials Until QlikView Exits Option is unchecked and click OK

Reopen your document Security2.qvw, try logging in as any of users (user1/user2). it is expected that the users see only one Country. Close your document and reopen it and log in as admin. Edit the script and in the Access table, Change the Link field Name from Link to LINK.Repeat this step for Link field in the Sales table.

Reload and save your document. Close and reopen the document. Log in ac user1. only USA should be listed. the same step you can use for User2, and if you log in as User2 so you see only United Kingdom

Dagan, let me know you have any questions. i hope that helps

beck

Anonymous
Not applicable
Author

Thanks a lot!

Anonymous
Not applicable
Author

what about sharing bookmarks with other users? any differences?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

As long as Server Collaboration has been enabled globally and for your particular document, everyone can share bookmarks. As I said before, in the AccessPoint there is no ADMIN role. Everyone is treated as a USER.

Best,

Peter

Anonymous
Not applicable
Author

how do I check this? - Server Collaboration has been enabled