Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Disable Functions ???

Hi All;

I would like to disable "Reload" and "Edit Script" functions according to documents or domain users?

I can disable these functions for all users except admin as you know...

Which one is possible and how can i do?

Thanks in advance...

1 Solution

Accepted Solutions
MVP
MVP

Disable Functions ???

Hello,

I'd do groups for users in a field out of the section access, and apply those fields to the conditional view of the sheet, in the sheet properties, General, Show Sheet, Conditional:

Section Access; LOAD * INLINE [ACCESS, NTNAME, NTDOMAINSIDADMIN, ADMINISTRATOR, S-1-5-21-4098164516-3443508128-318809462USER, SAKYUZ, S-1-5-21-4098164516-3443508128-318809462 ]; Section Application; UsersGroupsMap: // loaded manually, you can load from database or excel sheet for exampleLOAD * INLINE [ USERNAME, GROUPDOMAIN\ADMINISTRATOR, ADMINSDOMAIN\SAKYUZ, HRDOMAIN\USER1, SALES]; Groups:LOAD OSUser() AS User, ApplyMap('UsersGroupsMap', OSUser()) AS GroupAUTOGENERATE 1;


Now Sheet1 has conditional

Match(Group, 'HR', 'ADMINS')


Meaning that the sheet will be visible for users in group HR or ADMINS according to the sample above.

Note that NTNAME must match what OSUser() returns (usually in the form of DOMAIN\UserName) otherwise you will be locked out, so backup your document before reloading.

Hope that helps.

7 Replies
MVP
MVP

Disable Functions ???

Hello,

You need to create a section access, so QlikView can distinguish between user access and admin access. Note that if your deployment uses clients (AJAX or IE Plugin) all users are granted USER privileges, even if you have set them as ADMIN in the ACCESS field of section access. In other words, opening on server in Desktop, using IE Plugin and AJAX will not allow users to save or edit script or macro.

Besides, make sure that in the Settings menu, Document Properties, Open tab, "Initial Data Reduction..." and "Strict Exclusion" are unchecked.

// Sample Section AccessSECTION ACCESS;// Fields below are mandatoryLOAD * INLINE [ ACCESS, USERID, PASSWORDADMIN, ADMIN, ADMINUSER, USER1, USER1]; SECTION APPLICATION;// You script starts here


Hope that helps.

Disable Functions ???

Hi Selsuck

Addition to what Mrigun Says

You have to define what all the users can access and admin can access

for that go to Document Prooerties--> Security --> and removes the checks that you want to disable for the users.

and also make sure to check on Admin Override Security. It will be uncheck by default.

Save your application Close your Desktop.

Then Start Playing with it after opening again

Hope this is what you are looking for.

Regards

ASHFAQ

Not applicable

Disable Functions ???


Hi Miguel,

Thanks for replay.

i use like that below here:

Section Access;



LOAD

* INLINE

[

ACCESS, NTNAME, NTDOMAINSID

ADMIN, ADMINISTRATOR, S-1-5-21-4098164516-3443508128-318809462

USER, SAKYUZ, S-1-5-21-4098164516-3443508128-318809462









]

;





Section

Application;

I would like to do specific user access.
EX: HR Department have to see only sheet1 and sheet2, Accounting Department have to see only sheet3 and sheet4 in the same doc....

How can i do ?

Thanks in advance...

Disable Functions ???

Hi

For this I suggest you to go through Basic Section access attached to this document.

Hope thats help you

Regards

ASHFAQ

MVP
MVP

Disable Functions ???

Hello,

I'd do groups for users in a field out of the section access, and apply those fields to the conditional view of the sheet, in the sheet properties, General, Show Sheet, Conditional:

Section Access; LOAD * INLINE [ACCESS, NTNAME, NTDOMAINSIDADMIN, ADMINISTRATOR, S-1-5-21-4098164516-3443508128-318809462USER, SAKYUZ, S-1-5-21-4098164516-3443508128-318809462 ]; Section Application; UsersGroupsMap: // loaded manually, you can load from database or excel sheet for exampleLOAD * INLINE [ USERNAME, GROUPDOMAIN\ADMINISTRATOR, ADMINSDOMAIN\SAKYUZ, HRDOMAIN\USER1, SALES]; Groups:LOAD OSUser() AS User, ApplyMap('UsersGroupsMap', OSUser()) AS GroupAUTOGENERATE 1;


Now Sheet1 has conditional

Match(Group, 'HR', 'ADMINS')


Meaning that the sheet will be visible for users in group HR or ADMINS according to the sample above.

Note that NTNAME must match what OSUser() returns (usually in the form of DOMAIN\UserName) otherwise you will be locked out, so backup your document before reloading.

Hope that helps.

Not applicable

Disable Functions ???

Hi Miguel;

Thank you for your solution,

if we do not write ADMINS in Match function, Admins will not see the Sheet... right?

Or Admins see all Sheets in every case ?

MVP
MVP

Disable Functions ???

Hi,

If you don'r write admins, they will not see the sheet, as any other user.

Regards.

Community Browser